Re: File system snapshots for multiple file systems

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.

-- 
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/