Re: [PATCHES] Point in Time Recovery - Mailing list pgsql-hackers

From markw@osdl.org
Subject Re: [PATCHES] Point in Time Recovery
Date
Msg-id 200407271741.i6RHfd103421@mail.osdl.org
Whole thread Raw
List pgsql-hackers
On 26 Jul, To: simon@2ndquadrant.com wrote:
> Sorry I wasn't clearer.  I think I have a better idea about what's going
> on now.  With the archiving enabled, it looks like the database is able
> to complete 1 transaction per database connection, but doesn't complete
> any subsequent transactions. I'm not sure how to see what's going on.
> Perhaps I should try a newer snapshot from CVS while I'm at it?

I tried to do an strace on the postmaster (and child processes) to see
if that might show something, but when the postmaster starts the
database isn't accepting any connections.  I have the feeling it's not
really starting up.  Trying to shut it down seems to agrees with that.
My wild guess is that the database is sitting waiting for something when
a stored function is called but I'm not sure how to verify that.

Mark


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Savepoints inside functions
Next
From: Tom Lane
Date:
Subject: Re: Savepoints inside functions