Re: PostgreSQL 9.2 high replication lag

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(at)sud0(dot)nz> 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.
> [image: image.png]
>
> 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,
>
> Lucas
>
> This message is *encrypted*. Both the *Public Key* and the *GPG encrypted
> message* are included in this email so that you can verify its origin.
>
>
>
>

--

[image: Ausvet Logo] <https://www.ausvet.com.au/>

Dr Ben Madin

BVMS MVPHMgmt PhD MANZCVS GAICD
Managing Director
Mobile:
+61 448 887 220 <+61448887220>
E-mail:
ben(at)ausvet(dot)com(dot)au
Website:
www.ausvet.com.au
Skype: benmadin
Address:
5 Shuffrey Street
Fremantle, WA 6160
Australia