Re: Snapshot backups

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: James Sewell <james(dot)sewell(at)lisasoft(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Snapshot backups
Date: 2013-07-31 03:22:24
Message-ID: CAMkU=1xG2zL2w-rjKceP8yM24A_jNtW-9LobHPKS-mrpdxfBDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-07-31 05:13:50 Re: Snapshot backups
Previous Message Adrian Klaver 2013-07-31 02:25:29 Re: more fun with building 9.3beta2