From: Jesper Krogh <jesper@krogh.cc>
To: Ivan Voras <ivoras@freebsd.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Backup strategies
Date: Wed, 15 Oct 2008 11:46:36 +0200
Message-ID: <48F5BBFC.80404@krogh.cc> (raw)
In-Reply-To: <gd4d7q$3ed$1@ger.gmane.org>
References: <48F4D693.9000304@lerner.co.il>
<gd4d7q$3ed$1@ger.gmane.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jesper@krogh.cc, ivoras@freebsd.org
Subject: Re: Backup strategies
In-Reply-To: <48F5BBFC.80404@krogh.cc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox