Re: [PATCHES] Point in Time Recovery

From: markw(at)osdl(dot)org
To: markw(at)osdl(dot)org
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCHES] Point in Time Recovery
Date: 2004-07-27 17:41:48
Message-ID: 200407271741.i6RHfd103421@mail.osdl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 26 Jul, To: simon(at)2ndquadrant(dot)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

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Jowett 2004-07-27 22:19:03 Re: [HACKERS] Binary Cursors, and the COPY command
Previous Message Tom Lane 2004-07-27 16:41:04 Re: casting strings to multidimensional arrays yields strange results