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??
cheers
Ben
On Wed, 14 Jul 2021 at 09:10, Lucas <root@xxxxxxx> wrote:
Hello all,I have a cluster of PostgreSQL 9.2 servers (yes, I know... we're working on a migration to PG 13) that has one master and one slave.I know that the streaming replication is expected to have delays, but this is getting worse and worse everyday. You can see the replication gap is reaching >10 minutes quite often.The servers are hosted in AWS as EC2 instances and they're both in different AZs. I also know that the streaming replication was first introduced in PG 9.0, so we're using a very old version of it.. I'm sure it has improved over the years...What can I look for to make this lag not so high? Is there anything I could change in my postgresql.conf files? Any tips?Thanks!---Regards,LucasThis message is encrypted. Both the Public Key and the GPG encrypted message are included in this email so that you can verify its origin.
Dr Ben Madin
BVMS MVPHMgmt PhD MANZCVS GAICD
Managing Director
