Re: PostgreSQL 9.2 high replication lag - Mailing list pgsql-general

From Lucas
Subject Re: PostgreSQL 9.2 high replication lag
Date
Msg-id bAWCXagvacUhUSqS4H1wrgwN7qDc5ghc2vvOqMhBKEkTbx4Sk3TgRrEYRJ0g2gLIfebiCR0yZjp8WVTBHAvAXSCQ-Gb9H7OEc_AasD_H320=@sud0.nz
Whole thread Raw
In response to Re: PostgreSQL 9.2 high replication lag  (Ben Madin <ben@ausvet.com.au>)
List pgsql-general
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Friday, August 20th, 2021 at 4:56 PM, Ben Madin <ben@ausvet.com.au> wrote:

I realise you may have other complications, but we have upgraded numerous v9.6 servers (on AWS) to v12 in the last year, with basically no problems in the upgrade, and many less problems with streaming. It might take less time to complete the upgrade??


Hi Ben. Thanks for your reply.

I have a Bucardo replication between my EC2 instance PG 9.2 database and RDS running PG 13. We have completed a couple of tests already (including a stress/load test). But the business thinks is too risky to move all customers to RDS at once. They wanted to do it gradually which complicates my life as I would need a bidirectional replication in place.

So, I'm still trying to convince them to migrate all customers at once.... :(

Lucas
Attachment

pgsql-general by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Make bloom extension trusted, but can not drop with normal user
Next
From: Lucas
Date:
Subject: Re: PostgreSQL 9.2 high replication lag