PostgreSQL password for postgres

zosrothko's Avatar


01 Mar, 2016 05:21 PM


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

    Feodor Fitsner's Avatar

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

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

    zosrothko's Avatar

    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

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

    Feodor Fitsner's Avatar

    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:

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

    fredrik.averpil's Avatar

    Here's what I did which worked great:

    build: false
        - PY27:
          PYTHON: "C:\\Python27-x64"
          RUBY_VERSION: "22"
        - PY35:
          PYTHON: "C:\\Python35-x64"
          RUBY_VERSION: "22"
      - 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
      - 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"
      - postgresql93
        - psql -c "CREATE DATABASE stalker_test;" -U postgres
        - psql -c "CREATE USER stalker_admin WITH PASSWORD 'stalker';" -U postgres
      - nosetests --verbosity=1 --cover-erase --with-coverage --cover-package=stalker
  5. zosrothko closed this discussion on 17 May, 2018 09:08 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac