Skip to content

Instantly share code, notes, and snippets.

@Xarkam

Xarkam/Update postgresql 9.3 to 9.4 on Linux.txt

Last active July 16, 2019 07:57
Show Gist options
  • Save Xarkam/4b3b492d259b3d0a7b11ae07908e37eb to your computer and use it in GitHub Desktop.
Save Xarkam/4b3b492d259b3d0a7b11ae07908e37eb to your computer and use it in GitHub Desktop.
Download ZIP
Update postgresql 9.3 to 9.4 on Linux
Raw
Update postgresql 9.3 to 9.4 on Linux.txt
Steps:
1. uninstall Postgres 9.4
2. install 9.3
3. backup the database using pg_dumpall > backup.sql
4. uninstall Postgres 9.3
5. install Postgres 9.4
6. restore the databases using psql -d postgres -f backup.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment