[pgpool-general: 6545] Re: Not quite getting what "replication delay" is representing ... ?
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
> 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!
SRA OSS, Inc. Japan
More information about the pgpool-general