Re: Backup strategies

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