On Tue, 2010-04-27 at 20:14 +0300, Heikki Linnakangas wrote: > Simon Riggs wrote: > > On Tue, 2010-04-27 at 18:13 +0300, Heikki Linnakangas wrote: > >> Simon Riggs wrote: > >>> If pg_stop_backup() is run it creates the .backup file in the archive. > >>> In the absence of that file, we should be able to work out that > >>> pg_stop_backup() was not run. > >> It's just as likely that the file is there even though the backup didn't > >> finish, though. > > > > It's possible, but not likely. It would need to break at a very specific > > place for that to be the case. Whereas the test I explained would work > > for about 99% of the time between start and stop backup, except for the > > caveat I explained also. > > I don't understand how you arrived at that figure.
You're talking about the backup_label file, I'm talking about the .backup file in the archive. -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers