Re: Snapshot and pg_hotbackup - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Snapshot and pg_hotbackup
Date
Msg-id 4A9D1EE0020000250002A79F@gw.wicourts.gov
Whole thread Raw
In response to Snapshot and pg_hotbackup  ("Arnold, Sandra" <ArnoldS@osti.gov>)
List pgsql-admin
"Arnold, Sandra" <ArnoldS@osti.gov> wrote:

> Using tar for a small database is not a problem is when you have a
> database that will be close to a Terrabyte in size it can be a
> problem.  I was wondering if changing the file system backup
> solution to a snapshot instead has been done.

If snapshots turn out not to work well for you, and any significant
portions of the data remain unchanged from one base backup to the
next, you might want to check out this thread and the one it
references:

http://archives.postgresql.org/pgsql-admin/2009-07/msg00071.php

-Kevin

pgsql-admin by date:

Previous
From: "Arnold, Sandra"
Date:
Subject: Snapshot and pg_hotbackup
Next
From: Rafael Domiciano
Date:
Subject: Re: ERROR: syntax error at or near "NEW"