[Pgpool-general] Help getting pgpool setup with hot standby.

[Tatsuo Ishii]

> Tatsuo,
> 
> Here is my log.  I started pgpool II and then connected in from my laptop
> and issued a select count(*) from public.accounts.  Since this is a simple
> select, so I'm understanding that it should have gone to the slave.
> 
> Here is the log:
> 
> postgres at tstsrv:/usr/local/pgpool2/etc$ ../bin/pgpool -f ./pgpool.conf -F
> ./pcp.conf -n -d
[snip]

It seems pgpool-II remembers previous state when node 1 was down. Can
you try to start pgpool with adding -D option?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp