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

[tuanhoanganh]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20101119/eebe7bdb/attachment-0001.html>