Re: Backup strategies

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: Ivan Voras <ivoras(at)freebsd(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Backup strategies
Date: 2008-10-15 09:46:36
Message-ID: 48F5BBFC.80404@krogh.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-10-15 10:13:51 Re: Backup strategies
Previous Message Joao Ferreira gmail 2008-10-15 09:39:36 Re: run postgres 8.3

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2008-10-15 10:13:51 Re: Backup strategies
Previous Message Ivan Voras 2008-10-15 09:30:40 Re: Backup strategies