Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9A77D64FD82 for ; Wed, 15 Oct 2008 07:19:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 90086-08 for ; Wed, 15 Oct 2008 07:19:40 -0300 (ADT) X-Greylist: delayed 00:32:42.212966 by SQLgrey-1.7.6 Received: from shrek.krogh.cc (2605ds1-ynoe.1.fullrate.dk [90.184.12.24]) by postgresql.org (Postfix) with ESMTP id F284364FD91 for ; Wed, 15 Oct 2008 07:19:37 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by shrek.krogh.cc (Postfix) with ESMTP id ACB983BF51E; Wed, 15 Oct 2008 11:46:50 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at shrek.krogh.cc Received: from shrek.krogh.cc ([127.0.0.1]) by localhost (shrek.krogh.cc [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id yjL2DnujWcZS; Wed, 15 Oct 2008 11:46:36 +0200 (CEST) Received: from [127.0.0.1] (localhost.localdomain [127.0.0.1]) by shrek.krogh.cc (Postfix) with ESMTP id 60D563BF510; Wed, 15 Oct 2008 11:46:36 +0200 (CEST) Message-ID: <48F5BBFC.80404@krogh.cc> Date: Wed, 15 Oct 2008 11:46:36 +0200 From: Jesper Krogh User-Agent: Thunderbird 2.0.0.16 (X11/20080724) MIME-Version: 1.0 To: Ivan Voras CC: pgsql-performance@postgresql.org Subject: Re: Backup strategies References: <48F4D693.9000304@lerner.co.il> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200810/80 X-Sequence-Number: 31661 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