What does your pgpool.conf say about logging: # Logging directory
logdir = '/var/log' Jose Autonomy Ops verificare tua hinc From: [email protected] [mailto:[email protected]] On Behalf Of Sandeep Thakkar Sent: Wednesday, August 31, 2011 4:58 AM To: Sandeep Thakkar; [email protected] Subject: Re: [Pgpool-general] online recovery fails on HPUX I see following two lines when the pcp_recovery_node is fired.. Also, I cannot find recovery.log, but recovery.conf is present in standby cluster directory.. .... 2011-08-31 05:49:22 LOG: pid 20430: starting recovering node 1 2011-08-31 05:49:22 ERROR: pid 20430: start_recover: could not connect master node. .... The pg_hba.conf has the following entry: # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust host replication edb 127.0.0.1/32 trust ________________________________ From: Sandeep Thakkar <[email protected]> To: "[email protected]" <[email protected]> Sent: Tuesday, August 30, 2011 2:44 PM Subject: [Pgpool-general] online recovery fails on HPUX Hi, I'm using Postgres Plus Advanced Server on HP-UX 11.31 and found that the online recovery does not work here. pgPool version is 3.0.3-4 $pcp_recovery_node -d 20 localhost 9898 edb edb 1 DEBUG: send: tos="R", len=41 DEBUG: recv: tos="r", len=21, data=AuthenticationOK DEBUG: send: tos="D", len=6 DEBUG: recv: tos="e", len=20, data=recovery failed DEBUG: command failed. reason=recovery failed BackendError DEBUG: send: tos="X", len=4 I can see the following in the log: .... LOG: incomplete startup packet LOG: connection failed during start up processing: user= database= .... Moreover, I do not see pgpool_recovery_node statement in the log, so wondering if it is really getting executed. I have tried my scripts on Linux and it worked all fine. So, there is no issue with the pgpool.conf or my basebackup and other files.. Could this be an issue of HPUX? Thanks. _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
