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.
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
