On Tue, Oct 25, 2011 at 10:06 PM, Chris Redekop <chris@replicon.com> wrote:
>> Chris, can you rearrange the backup so you copy the pg_control file as
>> the first act after the pg_start_backup?
> I tried this and it doesn't seem to make any difference.
It won't, that was a poor initial diagnosis on my part.
> I also tried the
> patch and I can no longer reproduce the subtrans error
Good
>, however instead it
> now it starts up, but never gets to the point where it'll accept
> connections. It starts up but if I try to do anything I always get "FATAL:
> the database system is starting up"...even if the load is removed from the
> primary, the standby still never finishes "starting up".
...
> 2011-10-25 13:43:25.019 MDT [15072]: [14-1] LOG: consistent state delayed
> because recovery snapshot incomplete
...
This is a different problem and has already been reported by one of
your colleagues in a separate thread, and answered in detail by me
there. There is no bug related to this error message.
From here, it looks like the published fixes the originally reported problem.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services