Geek Answers Handbook

How to downgrade / have a previous version of Postgres DB in Postgres.app

I installed Postgres.app from here ( http://postgresapp.com ) a couple of days ago. It comes with Postgres 9.4.4.

Today I realized that the software I use officially supports only Postgres 9.3. Version 9.4.4 works, but sometimes there are DB locks.

Is there a way to downgrade my current db (a very small size created just for testing), which is version 9.4.4 to 9.3? Or is it possible to create another database with version 9.3 without deleting the current version of Postgres.app?

OS: OS X Yosemite 10.10.4

Thanks.

+6
source share
2 answers
  • install the postgres 9.3 server and client on your Mac.
  • run locate initdb expected in /Library/PostgreSQL/9.3/bin/initdb let's say that it is
  • create instance 9.3 /Library/PostgreSQL/9.3/bin/initdb -D /new_data_directory
  • export 9.4 db /Library/PostgreSQL/9.3/bin/pg_dump -U 94_username -d 94_database >somefile.dmp
  • shutdown old /Library/PostgreSQL/9.4/bin/pg_ctl stop -m fast
  • startup new /Library/PostgreSQL/9.3/bin/pg_ctl start 7.Create 93 dB /Library/PostgreSQL/9.3/bin/psql -U 93_superuser_user -c "create database IMPORT_DB"
  • import 93 db /Library/PostgreSQL/9.3/bin/psql -U 93_superuser_user -f somefile.dmp IMPORT_DB

I do not know if there are articles on this topic. I know that I'm old, but maybe a guide? :) and experience

+3
source

If you need to downgrade Postgres but prefer to continue using Postgres.app, there are previous releases recorded at https://github.com/PostgresApp/PostgresApp/releases/ , including links to dmg or older zip installers.

For example, in August 2017, the current Postgres.app ( v2.0.4 ) uses the version of Postgres 9.6.4 . However, if you need to tell Postgres 9.6.2 , you can revert to previous versions to find that the release v.2.0.2 from February 2017 uses Postgres 9.6.2 . https://github.com/PostgresApp/PostgresApp/releases/tag/v2.0.2

Older versions of Postgres will also revert to the 9.3 series mentioned in the original question.

I'm not sure that the old installers are "officially" provided by Postgres.app. I could not find their mention at http://postgresapp.com/ . Just noticed the release history on Github.

0
source

More articles:


All Articles