Last active
June 14, 2016 17:08
-
-
Save jphenow/4c8f02a502e464a87a59164d14cc87c8 to your computer and use it in GitHub Desktop.
9.5 became the Postgres Default on Circle CI
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# ... | |
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