X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2457F11F712D for ; Tue, 11 Apr 2006 07:40:12 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=0 required=5 tests=[none] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id uFRxKoSMF1on for ; Tue, 11 Apr 2006 07:40:02 -0300 (ADT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 9219111F7040 for ; Tue, 11 Apr 2006 07:40:05 -0300 (ADT) Received: from mx11.cksoft.de (mx11.cksoft.de [62.111.66.11]) by svr4.postgresql.org (Postfix) with ESMTP id 29A2E5AF83C for ; Tue, 11 Apr 2006 10:40:05 +0000 (GMT) Received: from vesihiisi.cksoft.de (unknown [192.168.64.10]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by mx12.cksoft.de (Postfix) with ESMTP id 1364DB9AF; Tue, 11 Apr 2006 12:39:56 +0200 (CEST) Received: from vesihiisi.cksoft.de (localhost [127.0.0.1]) by vesihiisi.cksoft.de (Postfix) with ESMTP id 8BF151EB5; Tue, 11 Apr 2006 12:39:52 +0200 (CEST) Received: by vesihiisi.cksoft.de (Postfix, from userid 1000) id 8D7471EA9; Tue, 11 Apr 2006 12:39:48 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by vesihiisi.cksoft.de (Postfix) with ESMTP id 8B3251EA1; Tue, 11 Apr 2006 12:39:48 +0200 (CEST) Date: Tue, 11 Apr 2006 12:39:48 +0200 (CEST) From: Christian Kratzer X-X-Sender: ck@vesihiisi.cksoft.de Reply-To: Christian Kratzer To: "Spiegelberg, Greg" Cc: pgsql-admin@postgresql.org Subject: Re: FW: Setting up of PITR system. In-Reply-To: <82E74D266CB9B44390D3CCE44A781ED90B6375@POSTOFFICE.cranel.local> Message-ID: <20060411123454.B2660@vesihiisi.cksoft.de> References: <82E74D266CB9B44390D3CCE44A781ED90B6375@POSTOFFICE.cranel.local> X-Spammer-Kill-Ratio: 75% MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by AMaViS cksoft-s20020300-20031204bz on vesihiisi.cksoft.de X-Archive-Number: 200604/96 X-Sequence-Number: 21265 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