X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id BDBA0D1B8A3 for ; Thu, 4 Sep 2003 22:23:58 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 54518-07 for ; Thu, 4 Sep 2003 19:23:30 -0300 (ADT) Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242]) by svr1.postgresql.org (Postfix) with ESMTP id 83211D1B8B1 for ; Thu, 4 Sep 2003 19:23:27 -0300 (ADT) Received: from lhosts ([68.11.66.83]) by lakemtao03.cox.net (InterMail vM.5.01.06.04 201-253-122-130-104-20030726) with ESMTP id <20030904222329.EQFO10812.lakemtao03.cox.net@lhosts> for ; Thu, 4 Sep 2003 18:23:29 -0400 Subject: Re: Backup? From: Ron Johnson To: PgSQL General ML In-Reply-To: References: <1062703912.28376.31.camel@pennywise.havleik.no> Content-Type: text/plain; charset=ISO-8859-1 Message-Id: <1062714209.17023.143.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Thu, 04 Sep 2003 17:23:30 -0500 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/397 X-Sequence-Number: 48619 On Thu, 2003-09-04 at 15:40, Doug McNaught wrote: > Bjørn T Johansen writes: > > > Should one use pg_dumpall to backup the database or is it more practical > > to just copy the data directory? > > The data directory will not be consistent unless the server is > stopped. pg_dumpall works well, produces a consistent backup and is > easily portable to a different machine architecture if need be. And it's smaller than the data/ directory, especially when "-F c" option is used. -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA "The UN couldn't break up a cookie fight in a Brownie meeting." Larry Miller