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.
Updating to version 10.8 helped.
thank You all for your help.
On Wed, 12 Jun 2019 at 20:49, Andrew Gierth
wrote:
> > "Evaldas" == Evaldas Užpalis writes:
>
> Evaldas> Hello PostgresSQL users and admins,
> Evaldas> I need some help with my problem.
>
> Evaldas> I looked at postgresql logs
> "Evaldas" == Evaldas Užpalis writes:
Evaldas> Hello PostgresSQL users and admins,
Evaldas> I need some help with my problem.
Evaldas> I looked at postgresql logs and it is littered with error messages
like:
Evaldas> ERROR: found xmin 3875696185 from before relfrozenxid 1599104090
E
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
