Postgres versions are not compatible

Question

I'm having trouble starting postgres as you can see below:

$ pg_ctl -D /usr/local/var/postgres start
server starting
FATAL:  database files are incompatible with server
DETAIL:  The data directory was initialized by PostgreSQL version 9.1, which is not compatible with this version 9.3.0.

Anyone know how to make the versions compatible?

The versions are not compatible. period. Upgrade from 9.1 to 9.2 or 9.3 requires a dump + restore. You'll have to have a running 9.1 installation to perform the dump. So you'll have to downgrade the binaries to 9.1 first. (this could be done by using two versions running-in-parallel, in different data directories, with different portnumbers, etc) — wildplasser
– wildplasser, Commented Sep 29, 2013 at 10:39
Please read this: postgresql.org/docs/current/static/upgrading.html — user330315
– user330315, Commented Sep 29, 2013 at 10:47

Tomasz Myrta · Accepted Answer · 2013-09-29 10:43:33Z

1

You have two choices:

Run 9.1 version, dump your database and restore it using 9.3
http://www.postgresql.org/docs/9.3/static/pgupgrade.html

answered Sep 29, 2013 at 10:43

Tomasz Myrta

1,1449 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Arta Over a year ago

And how do you run a specific version (installed by homebrew)?

Tomasz Myrta Over a year ago

You can have multiple postgres running different version at once. They just need to point to different data directory and have different listen port. Another approach is to uninstall 9.1 before installing 9.3.

Arta Over a year ago

This does not answer how to do that. I found out somewhere, the answer is: $ brew switch postgresql <target.version.number>

Collectives™ on Stack Overflow

Postgres versions are not compatible

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related