Re: Snapshot backups - Mailing list pgsql-general

From Jeff Janes
Subject Re: Snapshot backups
Date
Msg-id CAMkU=1xG2zL2w-rjKceP8yM24A_jNtW-9LobHPKS-mrpdxfBDQ@mail.gmail.com
Whole thread Raw
In response to Re: Snapshot backups  (James Sewell <james.sewell@lisasoft.com>)
Responses Re: Snapshot backups
List pgsql-general
On Tuesday, July 30, 2013, James Sewell wrote:
I understand what you are saying, and I understand how the backup_label works - but I still don't understand why the pg_start and pg_stop commands are REQUIRED when doing a snapshot backup to ensure data integrity. 

Surely not using them and restoring a snapshot is the same as starting after a crash, and will result in log replay to get to the latest possible consistent state?

That's true provided that all of your data is on a single volume, and you trust your "snapshot" to be free of bugs.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: more fun with building 9.3beta2
Next
From: Tom Lane
Date:
Subject: Re: Snapshot backups