[pgpool-general: 1977] Re: pgpool fails to start with version 3.3.0

[Wolf Schwurack]

Thanks that was the problem I missed that parameter setting

Wolf

From: Rene Romero Benavides [mailto:rene.romero.b at gmail.com]
Sent: Thursday, August 01, 2013 9:52 AM
To: Wolf Schwurack
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 1975] pgpool fails to start with version 3.3.0

 wd_check_config: there is no other pgpools setting

can you show us your new pgpool.conf?
as the message says, you're probably missing these parameters or are wrong:

other_pgpool_hostname0 = 'nodo1'
other_pgpool_port0 = 5432
other_wd_port0 = 9000

2013/8/1 Wolf Schwurack <wolf at uen.org<mailto:wolf at uen.org>>
I install the latest version of pgpool-II-3.3.0. When I use the new pgpool.conf.sample-stream pgpool fails to start. If I use the old pgpool.conf (3.2.5) pgpool starts up. I'm using the same parameters I set in the old pgpool.conf and input them into the new pgpool.conf

Am I missing a parameter setting

Using pgpool.conf(3.3.0) startup log
2013-08-01 08:40:15 LOG:   pid 17118: wd_chk_setuid: ifup[/sbin/ifconfig] doesn't have setuid bit
2013-08-01 08:40:15 LOG:   pid 17118: Backend status file /tmp/pgpool_status discarded
2013-08-01 08:40:15 ERROR: pid 17118: wd_check_config: there is no other pgpools setting.
2013-08-01 08:40:15 ERROR: pid 17118: watchdog: wd_check_config failed
2013-08-01 08:40:15 ERROR: pid 17118: wd_main error
2013-08-01 08:40:15 ERROR: pid 17118: unlink(/tmp/.s.PGSQL.9898) failed: No such file or directory

Using pgpool.conf (3.2.5) startup log
2013-08-01 08:37:00 LOG:   pid 16930: wd_chk_setuid: ifup[/sbin/ifconfig] doesn't have setuid bit
2013-08-01 08:37:00 LOG:   pid 16930: Backend status file /tmp/pgpool_status discarded
2013-08-01 08:37:00 LOG:   pid 16930: wd_create_send_socket: connect() reports failure (Connection refused). You can safely ignore this while starting up.
2013-08-01 08:37:00 LOG:   pid 16930: send_packet_4_nodes: packet for pgtest-con2:9000 is canceled
2013-08-01 08:37:03 LOG:   pid 16930: wd_escalation: escalatting to master pgpool
2013-08-01 08:37:05 LOG:   pid 16930: wd_escalation: escalated to master pgpool successfully
2013-08-01 08:37:05 LOG:   pid 16930: wd_init: start watchdog
2013-08-01 08:37:05 LOG:   pid 16930: pgpool-II successfully started. version 3.3.0 (tokakiboshi)
2013-08-01 08:37:05 LOG:   pid 16930: find_primary_node: primary node id is 0

      0___      Wolfgang Schwurack
     c/  /'_    DBA/SA
    (*)  \(*)   University of Utah/UEN
                Tel: (801) 587-9444<tel:%28801%29%20587-9444>
                email: wolf at uen.org<mailto:wolf at uen.org>


_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
http://www.pgpool.net/mailman/listinfo/pgpool-general



--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130801/56ce02fd/attachment.html>