Re: Snapshot and pg_hotbackup

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Sandra Arnold" <ArnoldS(at)osti(dot)gov>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Snapshot and pg_hotbackup
Date: 2009-09-01 18:17:20
Message-ID: 4A9D1EE0020000250002A79F@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Arnold, Sandra" <ArnoldS(at)osti(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Wei Zheng 2009-09-02 15:39:25 Looking for real configuration data
Previous Message Arnold, Sandra 2009-09-01 16:08:26 Snapshot and pg_hotbackup