Re: File system snapshots for multiple file systems

Jonah H. Harris wrote:
> On Mon, Apr 7, 2008 at 2:58 PM, Heikki Linnakangas
> <heikki(at)enterprisedb(dot)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