Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group