Home > mailing lists

how to upgrade production PostgreSQL from 9.4 to 11.3 - Mailing list pgsql-general

From	Rahul Chordiya
Subject	how to upgrade production PostgreSQL from 9.4 to 11.3
Date	June 12, 2019 11:33:16
Msg-id	CAFySG5EwXJdg=PeXMzxDnaYWbj7z4bFX0JsbdUbr3ZsS2qPVeQ@mail.gmail.com Whole thread Raw
Responses	RE: how to upgrade production PostgreSQL from 9.4 to 11.3
List	pgsql-general

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

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

From: Thomas Kellerer
Date: 12 June 2019, 01:20:53
Subject: Re: Featured Big Name Users of Postgres

From: Andreas Kretschmer
Date: 12 June 2019, 13:31:35
Subject: Re: how to upgrade production PostgreSQL from 9.4 to 11.3