ces]<https://www.fujixerox.com.au/en/Company/Sustainability>
From: Rahul Chordiya
Sent: Wednesday, 12 June 2019 9:33 PM
To: pgsql-general@lists.postgresql.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
Hi Rahul,
You may look into the following blogs.
https://www.percona.com/blog/2019/04/12/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/
https://www.percona.com/blog/2019/04/04/replication-between-postgresql-versions-using-logical-replication/
https://www.percona.com/bl
Am 12.06.19 um 14:50 schrieb Rahul Chordiya:
postgres=#
postgres=# select subscription_name, status FROM
pglogical.show_subscription_status();
subscription_name | status
---+
(0 rows)
postgres=# select pglogical.create_subscription(subscription_name :=
'subscriptio
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
