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

Ndofunsu June 16, 2023

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

 

2 answers

0 votes
IKP Reddy January 21, 2024

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 ?

0 votes
Fabio Racobaldo _Herzum_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 17, 2023

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 June 19, 2023

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 19, 2023

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 June 19, 2023

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
AUG Leaders

Atlassian Community Events