Migration "confluence 7.13.8 to 7.19.6 and Postgresql from 9.6 to 13.10"

Question

Hi,

If I can I have some help about postgresql migration to resolve this case.

We are migrating Confluence 7.13.8 to 7.19.6 on linux server.

In the same time and according to confluence 7.19.6 prequisites, we have to migrate postgresql from 9.6   to 13.10  that are, 2 major Versions installed separately on 2  different linux servers server A and server B.

In this case, how and what is the reliable way to migrate Postgresql ?

Can I just use  pg_upgrade over network without replication and from my new Server B?

From my new server ServerB:

#pg_upgrade --old-datadir "@ServerA:/directory/date-dir-postgresql9.6 --new-datadir /directory/data-dir-postgresql13 --old-bindir "@ServerA:/directory/bin-dir/bin --new-bindir /directory/bin/

Best Regards,

Roger

IKP Reddy · Answer

Ndofunsu,

we are also in same situation.  Did you completed your DB upgrade in new server ?

May i know which steps you followed  to upgrade postgres10 from server A to postgres13 in server B ?

Ndofunsu · Answer

Hi @Fabio Racobaldo [Herzum]

Yes, I have already intalled postgresql 13.10 a major version on a new linux server B.

To transfer database from old major version 9.6 from linux server A, Documentation recommand pg_upgrade. fails with an errot!

check ... file not found !

fail, output

How to specify path with up_grade over network!!!

Best regards,

Roger

Fabio Racobaldo _Catworkx_ · Answer

Hi @Ndofunsu ,

you could upgrade DBMS on the new server and then import a backup of your DB from old server to the new one. It is the simplest way.