RE: how to upgrade production PostgreSQL from 9.4 to 11.3

Your best bet is to use Slony, can be time consuming and a lot of hassle for the initial setup but worth all that effort when the downtime is reduced (between seconds to a couple of minutes) for such a large system.
[Fuji Xerox Australia]
Nawaz Ahmed
Database Administrator

[http://xww.aus.xerox.com/staffdirectory/ebizcard/images/facebook.png]<https://www.facebook.com/FujiXeroxAustralia> [http://xww.aus.xerox.com/staffdirectory/ebizcard/images/twitter.png] <https://twitter.com/fujixeroxaus> [http://xww.aus.xerox.com/staffdirectory/ebizcard/images/linkedin.png] <http://www.linkedin.com/company/fuji-xerox-australia> [http://xww.aus.xerox.com/staffdirectory/ebizcard/images/youtube.png] <https://www.youtube.com/playlist?list=PL1624299D50FAA7C1> [http://xww.aus.xerox.com/staffdirectory/ebizcard/images/blog.png] <http://www.fujixerox.com.au/blog/>

[http://xww.aus.xerox.com/staffdirectory/ebizcard/images/feedback.png]<https://fujixerox.au1.qualtrics.com/jfe/form/SV_ehrj1apkwRRNKYZ>

Please think before you print and use duplex printing to preserve resources[Please think before you print and use duplex printing to preserve resources]<https://www.fujixerox.com.au/en/Company/Sustainability>
From: Rahul Chordiya <rahulchordiya(at)gmail(dot)com>
Sent: Wednesday, 12 June 2019 9:33 PM
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: how to upgrade production PostgreSQL from 9.4 to 11.3

Hi,

We have 2 TB of data on our production server, we want to use 11.3 or latest stable version of PostgreSQL as our DB server on aws EC2 instance.

I have tried couple of way to upgrade but they are not production friendly:

I have tried pg_upgrade but as it require to stop the server we can't do it.
I have tried with --link option too but it also take time.
I have created replication and I tried to take pg_basebackup using 11.3 version but the backup was created with 9.4 version.
I have also tried to do the same with pglogical but it is showing pglogical schema not found.

please tell me the proper way to upgrade our 2TB of production database.

--
Thanks & Regards

Rahul Chordiya
Tech-Geek && DevOps && Full Stack Developer
Mobile: +91 998 153 4313<tel:919981534313>

[🌳]

Please do not print this email unless absolutely necessary. Go GREEN, Go PAPERLESS
[🌳]

IMPORTANT NOTE: Fuji Xerox email transmission, including any attachments, is private and confidential and may contain legally privileged information. It is for the addressee's attention only. If you are not the intended recipient and have received this transmission, you must not use, edit, print, copy or disclose its contents to any person or disseminate the information contained herein or hereto attached, and you must notify sender immediately by return email and delete this transmission from your system. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. We have used reasonable efforts to protect this transmission from computer viruses and other malicious software, but no warranty is made and the sender takes no responsibility for any loss or damage incurred from using this email or the information contained in this email.