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

[Ndofunsu]

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]

Hi @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 ?

[Fabio Racobaldo _Herzum_]

Hi @Ndofunsu ,

my suggestion is to perform these steps in a test environment first. Your approach should work fine. Moreover, please take a look to the following article https://confluence.atlassian.com/jirakb/how-to-upgrade-from-postgresql-9-6-to-postgresql-12-1077906030.html

Hope this helps,

Fabio

[Ndofunsu]

Hi @Fabio Racobaldo _Herzum_ 

Thanks but pg_upgrade documentation explains that "Link mode also requires that the old and new cluster data directories be in the same file system".

In my case the old and new database are in 2 different linux servers so I have to use pg_upgradeto copy data base files  over the network.

Is pg_upgrade possible over network between 2 servers?

Best regards,

Roger

[Fabio Racobaldo _Herzum_]

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.

[Ndofunsu]

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