[Pgpool-general] Newbie questions

[Jacinta Carvalho]

Hello !

On 3/24/06, Doyon, Jean-Francois <Jean-Francois.Doyon at ccrs.nrcan.gc.ca> wrote:
> Very well ... So what happens to SQL statements right after the cable was
> unplugged, but before the health check ran?  It fails on the secondary
> server, but ran properly on the first?  More importantly, does the client
> get an error?
>
> Pgpool says nothing, even in -d mode.  I suspect it's because, without
> health checking,  the first connect attempt fails because my secondary
> server doesn't exist yet.  It enters degeneration mode the first time a
> client tries to connect, but the client gets an error when this happens.  On
> the second try, all works well.

If you don't have any log perhaps you should run pgpool with :
pgpool -n > /tmp/pgpool.log 2>&1 &

Best regards,
--
Jacinta Carvalho
jacinta.carvalho at gmail.com