On Tue, Oct 25, 2011 at 10:06 PM, Chris Redekop <ch...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers