[Pgpool-general] Simple Streaming replication setting with pgpool-II - Node Info do not display

[Tatsuo Ishii]

The log said standby server (5433) is not running.  Have you done
online recovery? In the tutorial it is assumed that standby server is
not running until on line recovery is performed.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> I have install pgpool 3.1.0 alpha 1 version. Here is pgpoolAdmin log
> 2010-11-19 06:42:14 ERROR: pid 8813: pool_init_pool_passwd: couldn't open
> /usr/local/etc/pool_passwd. reason: Permission denied
>  2010-11-19 06:42:14 LOG: pid 8813: Backend status file
> /var/log/pgpool/pgpool_status discarded
>  2010-11-19 06:42:14 LOG: pid 8813: pgpool-II successfully started. version
> 3.1.0-alpha1 (umiyameboshi)
>  2010-11-19 06:42:14 ERROR: pid 8847: connect_inet_domain_socket: connect()
> failed: Connection refused
>  2010-11-19 06:42:14 ERROR: pid 8847: make_persistent_db_connection:
> connection to localhost(5433) failed
>  2010-11-19 06:42:14 LOG: pid 8813: find_primary_node: primary node id is 0
>  2010-11-19 06:42:14 ERROR: pid 8813: connect_inet_domain_socket: connect()
> failed: Connection refused
>  2010-11-19 06:42:14 ERROR: pid 8813: health check failed. 1 th host
> localhost at port 5433 is down
>  2010-11-19 06:42:14 LOG: pid 8813: set 1 th backend down status
>  2010-11-19 06:42:14 LOG: pid 8813: starting degeneration. shutdown host
> localhost(5433)
>  2010-11-19 06:42:14 LOG: pid 8813: execute command:
> /usr/local/etc/failover.sh 1 "localhost" 5433 /opt/PostgreSQL/9.0/data_5433
> 0 0 "localhost" 0
>  2010-11-19 06:42:14 LOG: pid 8813: failover_handler: set new master node: 0
> 
>  2010-11-19 06:42:14 LOG: pid 8813: failover done. shutdown host
> localhost(5433)
>  2010-11-19 06:42:14 LOG: pid 8813: find_primary_node: primary node id is 0
> On Fri, Nov 19, 2010 at 11:58 AM, tuanhoanganh <hatuan05 at gmail.com> wrote:
> 
>> I was follow website
>> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html
>> But when i click Node Info nothing display, click to Summary, Process Info,
>> Log work well.
>>
>> This is pgpoolAdmin log
>> 2010-11-19 05:48:20 ERROR: pid 2779: pool_init_pool_passwd: couldn't open
>> /usr/local/etc/pool_passwd. reason: Permission denied
>>  2010-11-19 05:48:20 LOG: pid 2779: Backend status file
>> /var/log/pgpool/pgpool_status discarded
>>  2010-11-19 05:48:20 LOG: pid 2779: pgpool-II successfully started.
>> version 3.0.1 (umiyameboshi)
>>  2010-11-19 05:48:21 ERROR: pid 2779: connect_inet_domain_socket:
>> connect() failed: Connection refused
>>  2010-11-19 05:48:21 ERROR: pid 2779: health check failed. 1 th host
>> localhost at port 5433 is down
>>  2010-11-19 05:48:21 LOG: pid 2779: set 1 th backend down status
>>  2010-11-19 05:48:21 LOG: pid 2779: starting degeneration. shutdown host
>> localhost(5433)
>>  2010-11-19 05:48:21 LOG: pid 2779: execute command:
>> /usr/local/etc/failover.sh 1 "localhost" 5433 /opt/PostgreSQL/9.0/data_5433
>> 0 0 "localhost"
>>  [: 24: =: argument expected
>>
>>  2010-11-19 05:48:21 LOG: pid 2779: failover_handler: set new master node:
>> 0
>>  2010-11-19 05:48:21 LOG: pid 2779: failover done. shutdown host
>> localhost(5433)
>> And psql -p 9999 -U postgres work well
>>
>> How to fix it
>>
>> Thanks in advance
>> Tuan Hoang Anh
>>