Home → Suggestions →

PostgreSQL password for postgres

• Edit

zosrothko

01 Mar, 2016 05:21 PM

Hi

In most if not all testing environement for PostgreSQL, the root user/pwd is postgres/postgres

Could you change the root usr/pwd of the postgresql instance to postgres/postgres?

1. Support Staff 1 Posted by Feodor Fitsner on 01 Mar, 2016 06:50 PM

   

   It's going to break many builds. Can you change the password from command line?

   • Edit

2. 2 Posted by zosrothko on 02 Mar, 2016 10:12 AM

   

   It is possible on my Win7 machine... but I do not know if this will work on AppVeyor..; will give try.. Just wondering, why did you use Password12! as password and not a standard postgres?

   By the way, we will need also the x86 version PostgreSQL 9.4. Could you install it as a standard service database ?

   There will be a problem for the listeing port: On our infrastructure, PostgreSQL x86 is listening on 5432 while PostgreSQL x64 is listening on 5464..

   Thanks in advance

   • Edit

3. Support Staff 3 Posted by Feodor Fitsner on 02 Mar, 2016 07:58 PM

   

   Well, that password is the same across all DBs on build workers. You can install any version of Postgre using the script. For example, this is how we currently install Postgre 9.4 x64: https://gist.github.com/FeodorFitsner/a2e945e4da9e2f40632b

   • Edit

4. 4 Posted by fredrik.averpil on 14 Feb, 2017 02:16 PM

   

   Here's what I did which worked great:

   build: false
   
   environment:  
     matrix:
       - PY27:
         PYTHON: "C:\\Python27-x64"
         RUBY_VERSION: "22"
       - PY35:
         PYTHON: "C:\\Python35-x64"
         RUBY_VERSION: "22"
   
   init:  
     - SET PATH=%PYTHON%;%PYTHON%\\Scripts;%PATH%
     - python --version
     - SET PATH=C:\Ruby22\bin;%PATH%
     - ruby -v
     - gem -v
     - SET PGUSER=postgres
     - SET PGPASSWORD=Password12!
     - SET PATH=C:\Program Files\PostgreSQL\9.3\bin\;%PATH%
     - psql --version
   
   install:  
     - gem install mime-types -v 2.6.2  # Required to install taskjuggler
     - gem install taskjuggler
     - "%PYTHON%/Scripts/pip.exe install sqlalchemy psycopg2 jinja2 alembic mako markupsafe python-editor nose coverage"
   
   services:  
     - postgresql93
   
   before_test:  
       - psql -c "CREATE DATABASE stalker_test;" -U postgres
       - psql -c "CREATE USER stalker_admin WITH PASSWORD 'stalker';" -U postgres
   
   test_script:  
     - nosetests --verbosity=1 --cover-erase --with-coverage --cover-package=stalker
   <pre><code></code>
   </pre>
   

   • Edit

5. zosrothko closed this discussion on 17 May, 2018 09:08 AM.