CODEWITHSUNDEEP
windowspostgresqlpostgresql-9.4postgresql-13pg-upgrade
Manoj Kumaar S
Manoj Kumaar S

Reputation: 11

is it possible to upgrade postgresql from 9.4 to 13.3 using pg_upgrade?

When i try to Upgrade 9.4 to 13 using pg_upgrade , the Upgrade stops in between with authentication failure using the password from pgpass.conf file .

The same approach works from 9.4 to 9.6

Here is the pg_upgrade command that i used

C:\postgresql\13\bin\pg_upgrade --old-datadir C:/PostgreSQL/9.4/data --new-datadir C:/PostgreSQL/13/data --old-bindir C:/PostgreSQL/9.4/bin --new-bindir C:/PostgreSQL/13/bin --old-port=5433 --new-port=5435 --username <superusername> --verbose

I am running this command from %temp%

Upvotes: 0

Views: 1337

Answers (1)

Jose Carvalho
Jose Carvalho

Reputation: 69

To do the migration, I used logical replication using the server with version 9.4 to replicate to a server with version 13. Another option would be to migrate using pg_dumpall and pg_restore.

Upvotes: 0

Related Questions