[Pgpool-general] Sync Problems with two pgpool nodes

Tatsuo Ishii ishii at sraoss.co.jp
Sat Aug 15 23:37:00 UTC 2009


> > >  The 2 pgpool instances, share the same 2 backends...
> >
> > As I said in my previous mail, I think that you can't use two
> > pgpool-II daemons against the two same back-ends at the same time.
> 
> 
> Do you know why? We are really curious about this..
> If two independent psql clients can share the same database without any
> problems, why two different pgpool instances cannot share the same backends?

Actually it's possible for two pgpool instances share the same
backends. However if you want to do online recovery, you should stop
other pgpool. Other wise it will mess up recovery process.
--
Tatsuo Ishii
SRA OSS, Inc. Japan


More information about the Pgpool-general mailing list