Skip to content

Instantly share code, notes, and snippets.

@jphenow
Last active June 14, 2016 17:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jphenow/4c8f02a502e464a87a59164d14cc87c8 to your computer and use it in GitHub Desktop.
Save jphenow/4c8f02a502e464a87a59164d14cc87c8 to your computer and use it in GitHub Desktop.
9.5 became the Postgres Default on Circle CI
# ...
dependencies:
override:
# Delete these two lines
- sudo service postgresql stop 9.4
- sudo cp -v /etc/postgresql/9.{4,5}/main/pg_hba.conf && sudo service postgresql restart 9.5
# ...
database:
override:
# Delete lines like these below. Yours won't be the same, but we had to do something
# like this to get connected to 9.5 before it became default due to our database
# setup.
- sudo -u postgres dropuser -p $DBPORT $USER
- sudo -u postgres createuser -p $DBPORT $USER
- sudo -u postgres createdb -p $DBPORT -O $USER $USER
- sudo -u postgres psql -p $DBPORT --command="ALTER USER $USER superuser"
# Then the 9.5 port was 5433 (when it wasn't default), now use 5432 to connect to the database
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment