X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EC4F23A552C for ; Mon, 24 Jan 2005 18:27:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80948-10 for ; Mon, 24 Jan 2005 18:27:05 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 396683A5472 for ; Mon, 24 Jan 2005 18:27:04 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 24 Jan 2005 12:27:02 -0600 Subject: Re: Postgres 8.0 Backups From: Scott Marlowe To: Tom Lane Cc: Pallav Kalva , pgsql-admin@postgresql.org In-Reply-To: <23143.1106589900@sss.pgh.pa.us> References: <41F52694.1090309@deg.cc> <1106586565.16640.90.camel@state.g2switchworks.com> <23143.1106589900@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1106591222.16640.108.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 24 Jan 2005 12:27:02 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/252 X-Sequence-Number: 16111 On Mon, 2005-01-24 at 12:05, Tom Lane wrote: > Scott Marlowe writes: > > On Mon, 2005-01-24 at 10:47, Pallav Kalva wrote: > >> I am working on a backup script for Postgres 8.0 online backups and > >> since i have to copy the whole pgdata directory , i am wondering after i > >> copy the pgdata directory can I run gzip or tar on the data directory ? > > > Generally speaking, file system level backups are not the best way to > > backup postgresql, since they require either shutting down the server or > > using a snapshot file system to get a coherent backup. > > In the context of online backup operations, that advice isn't relevant > anymore ... Really, is this an 8.0 thing then, that I can make file system backups and expect them to be coherent, or did I misunderhear what you meant and this has to do with some other issue I'm not getting?