Re: [HACKERS] postgres 9.0 crash when bringing up hot standby - Mailing list pgsql-admin

From Robert Haas
Subject Re: [HACKERS] postgres 9.0 crash when bringing up hot standby
Date
Msg-id AANLkTinw-_jp5erj0Oa=WbMdtOpvHX9vpWWTmcyofokr@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] postgres 9.0 crash when bringing up hot standby  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Thu, Aug 12, 2010 at 5:54 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I wrote:
>> I wonder if the problem is not so much libpqwalreceiver as the
>> walreceiver process.  Maybe an ordinary backend process does some
>> prerequisite initialization that walreceiver is missing.  Hard to
>> guess what, though ... I can't think of anything dlopen() depends on
>> that should be under our control.
>
> Actually, that idea is easily tested: try doing
>        LOAD 'libpqwalreceiver';
> in a regular backend process.

Alanoly, is this something you can try?

> If that still crashes, it might be useful to truss or strace the backend
> while it runs the command, and compare that to the trace of
>        LOAD 'dblink';

And if necessary, this too?

Thanks for your help debugging this....

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

pgsql-admin by date:

Previous
From: "Gnanakumar"
Date:
Subject: SQL statements not printed in pgpool log
Next
From: Ricardo Bayley
Date:
Subject: NEW + tableOID