[pgpool-general: 1303] Re: pgpool not load balancing

Greg Donald gdonald at gmail.com
Tue Jan 8 13:41:14 JST 2013

On Mon, Jan 7, 2013 at 4:43 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> Notice this message:
>> pool pgpool[11979]: connection on node 1 was terminated due to
>> conflict with recovery
> This is not pgpool's fault. i.e. You will see same error even if you
> directly connect to PostgreSQL standby node and this is a well known
> problem with PostgreSQL's streaming replication. Google "conflict with
> recovery" or read:
> http://www.postgresql.org/docs/9.2/static/hot-standby.html

I set

vacuum_defer_cleanup_age = 100

on the master and

max_standby_streaming_delay = -1

on the slaves.  Seems to be working.

Greg Donald

More information about the pgpool-general mailing list