| From: | Lucas <root(at)sud0(dot)nz> |
|---|---|
| To: | Ben Madin <ben(at)ausvet(dot)com(dot)au> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 9.2 high replication lag |
| Date: | 2021-08-22 23:43:59 |
| Message-ID: | bAWCXagvacUhUSqS4H1wrgwN7qDc5ghc2vvOqMhBKEkTbx4Sk3TgRrEYRJ0g2gLIfebiCR0yZjp8WVTBHAvAXSCQ-Gb9H7OEc_AasD_H320=@sud0.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Friday, August 20th, 2021 at 4:56 PM, Ben Madin <ben(at)ausvet(dot)com(dot)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 | Content-Type | Size |
|---|---|---|
| publickey - root@sud0.nz - 0xC5E964A1.asc | application/pgp-keys | 3.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lucas | 2021-08-22 23:47:09 | Re: PostgreSQL 9.2 high replication lag |
| Previous Message | Mladen Gogala | 2021-08-21 20:08:50 | Re: Make bloom extension trusted, but can not drop with normal user |