[pgpool-general: 6545] Re: Not quite getting what "replication delay" is representing ... ?

Tatsuo Ishii ishii at sraoss.co.jp
Sat May 4 23:21:52 JST 2019

> Thank you for the explanation, my apologies for the delay in replying.
> Trying these queries by hand revealed what I already knew - absolutely
> minimal replication lag over an hour long test period. Clearly
> something was going wrong, so I took another look at the pgpool.conf
> config file to see if I had missed something obvious.
> Turned out I had. There was a typo in the address for backend node 1,
> and it was pointing to the same server as node 0 (the FQDNs are
> unfortunately very similar). In effect, my primary and standby nodes
> were the same database. No wonder I was seeing significant replication
> lag!
> Very embarrassing, and obviously now fixed, but I was somewhat
> surprised that pgpool accepted that upon startup. Should there be a
> check to make sure the backends are, indeed, unique databases?

I never thought about the idea, but that sounds like an idea. Thanks!
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list