default Postgres is 14, database files are at v12

Question

My default Postgres (installed via brew) is at v14, and I can't start it because the files are at version 12:

DETAIL: The data directory was initialized by PostgreSQL version 12, which is not compatible with this version 14.0.

I can't upgrade the files:

==> Moving postgresql data back from /usr/local/var/postgres.old to /usr/local/var/postgres...
Error: Failure while executing; `/usr/local/opt/postgresql/bin/initdb --lc-collate=C --lc-ctype=C --lc-messages=C --lc-monetary=C --lc-numeric=C --lc-time=C -E\ UTF8 /usr/local/var/postgres` exited with 1.

There is also this error when I do brew services:

postgresql error /usr/local/opt/postgresql/homebrew.mxcl.postgresql.plist

I have version @12 installed but when I open it I can't see the databases in my default install.

What is the best path forward to resolve this?

Did you tried doing pgdump_all on the version 12 and later restore to version 14? — Jose Cabrera Zuniga
– Jose Cabrera Zuniga, Commented Oct 15, 2021 at 15:57
@JoseCabreraZuniga - no will pgdump_all work even though my default install is not running? — fatfrog
– fatfrog, Commented Oct 15, 2021 at 15:59
you might need to config your postgres 12 to use the folder where the DB files are located and try again. Out of that... I am out of options. — Jose Cabrera Zuniga
– Jose Cabrera Zuniga, Commented Oct 15, 2021 at 16:12
@JoseCabreraZuniga do you know what path I put in on OSX? Do I just put in /usr/local/var/postgres ? — fatfrog
– fatfrog, Commented Oct 15, 2021 at 16:46
Hope this link can help you: stackoverflow.com/questions/1137060/… — Jose Cabrera Zuniga
– Jose Cabrera Zuniga, Commented Oct 15, 2021 at 16:52

Jose Cabrera Zuniga · Accepted Answer · 2021-10-15 17:37:51Z

1

On your postgres 12 set the folder where the data you need (or a copy of this folder) as the working folder for postgres 12. Do pgdump on this version and then pg_restore on postgres 14.

Use the next link to identify the working folder:

Where does PostgreSQL store the database?

answered Oct 15, 2021 at 17:37

Jose Cabrera Zuniga

2,6857 gold badges40 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

default Postgres is 14, database files are at v12

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related