Re: File system snapshots for multiple file systems

Jonah H. Harris wrote:
> On Mon, Apr 7, 2008 at 2:58 PM, Heikki Linnakangas
> <heikki@enterprisedb.com> wrote:
>>  Incidentally, I looked at this stuff just a couple of days ago, and it
>> occurred to me that we really should make it easier to take a hot backup
>> with that mechanism. We shouldn't require setting up archive_command, and
>> WAL archiving, if all you want is to take a backup from a live system. From
>> user point of view, it should be a matter of:
>>
>>  1. call pg_start_backup('foo')
>>  2. tar/etc. the whole data directory, except for pg_xlog
>>  3. tar pg_xlog
>>  4. call pg_stop_backup()
>>
>>  If we just made sure that we don't delete or recycle any WAL files while
>> the backup is being taken, that would work, right?
> 
> Or checkpoint, yes?  I don't see tar backing up large (100+GB)
> databases in < 5 minutes.

Right.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com