[Pgpool-general] online recovery fails on HPUX

[Jose Mendoza]

I would reply to the general distribution but I am having trouble with
it.

 

This looks like an authentication issue to the database you might want
to use the .pgpass file to prepare access to the environment.

 

I hope that helps.

 

Jose

Autonomy Ops

verificare tua hinc

From: pgpool-general-bounces at pgfoundry.org
[mailto:pgpool-general-bounces at pgfoundry.org] On Behalf Of Jose Mendoza
Sent: Tuesday, August 30, 2011 1:56 PM
To: Sandeep Thakkar; pgpool-general at pgfoundry.org
Subject: Re: [Pgpool-general] online recovery fails on HPUX

 

Where is it failing at?

Can you provide info from your recovery.log?

 

 

Jose

Autonomy Ops

verificare tua hinc

From: pgpool-general-bounces at pgfoundry.org
[mailto:pgpool-general-bounces at pgfoundry.org] On Behalf Of Sandeep
Thakkar
Sent: Tuesday, August 30, 2011 2:14 AM
To: pgpool-general at pgfoundry.org
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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110830/c1ed5218/attachment.html>