From: Christian Kratzer <ck-lists@cksoft.de>
To: Spiegelberg, Greg <gspiegelberg@cranel.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: FW: Setting up of PITR system.
Date: Tue, 11 Apr 2006 12:39:48 +0200 (CEST)
Message-ID: <20060411123454.B2660@vesihiisi.cksoft.de> (raw)
In-Reply-To: <82E74D266CB9B44390D3CCE44A781ED90B6375@POSTOFFICE.cranel.local>
References: <82E74D266CB9B44390D3CCE44A781ED90B6375@POSTOFFICE.cranel.local>
Hi,
On Tue, 11 Apr 2006, Spiegelberg, Greg wrote:
> You should implement filesystem or volume level snapshots. LVM,
> Veritas and the like all have the functionality and it gets the
> database out of "backup" mode quickly.
from what I understand there is no need to keep the time between
pg_start_backup and pg_stop_backup small. The datebase is in no
way restrcited in its operation or performance during this time.
The only magic seems to be the marker file containing the information
which transaction were commited at the time the backup started.
As we run freebsd and our tar does not complain of files changing
underneath we prefer to avoid the additional complexity and of
filesystem snapshots and just plain tar the data directory
without the pg_xlog subdirectory.
Greetings
Christian
--
Christian Kratzer ck@cksoft.de
CK Software GmbH http://www.cksoft.de/
Phone: +49 7452 889 135 Fax: +49 7452 889 136
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: ck-lists@cksoft.de, gspiegelberg@cranel.com
Subject: Re: FW: Setting up of PITR system.
In-Reply-To: <20060411123454.B2660@vesihiisi.cksoft.de>
References: <82E74D266CB9B44390D3CCE44A781ED90B6375@POSTOFFICE.cranel.local> <20060411123454.B2660@vesihiisi.cksoft.de>
* 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