Re: Backup strategies - Mailing list pgsql-performance

From Jesper Krogh
Subject Re: Backup strategies
Date
Msg-id 48F5BBFC.80404@krogh.cc
Whole thread Raw
In response to Re: Backup strategies  (Ivan Voras <ivoras@freebsd.org>)
Responses Re: Backup strategies  (Ivan Voras <ivoras@freebsd.org>)
List pgsql-performance
Ivan Voras wrote:
> Warning: DO NOT do on-the-fly binary backups without snapshots.
> Archiving the database directory with tar on a regular file system,
> while the server is running, will result in an archive that most likely
> won't work when restored.

Even if you do a "pg_start_backup/pg_stop_backup" as specified here:

http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html
=> Making a Base backup.

??

It worked when I tested it, but I may just have been darn lucky.

--
Jesper

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Backup strategies
Next
From: Ivan Voras
Date:
Subject: Re: Backup strategies