[Pgpool-general] Replication conncetions failing; help with debugging?

Tatsuo Ishii ishii at sraoss.co.jp
Wed Sep 1 07:03:26 UTC 2010


> >> Do you have minimum self contained test case? Probably I need data for
> >> pgReplay and related DB dump.
> > 
> > This seems consistent enough that pgbench should probably reproduce it;
> > I'll try it tommorrow and send instructions if it does.
> 
> I've not been able to reproduce this with pgbench so far.  Clearly it's
> related to something specific to this database, which is unfortunately
> highly proprietary.
> 
> Is there any way I could get more information from pgpool on what's
> happening?  Like I said, the Postgres server logs show no error messages
> at all.

If your application is based on libpq, you could use PQtrace to
capture the packets exchanged between the client and pgpool. Also
packet capture tools should do the job as well.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the Pgpool-general mailing list