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 321A6D1B8A4 for ; Thu, 4 Sep 2003 20:41:15 +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 22710-05 for ; Thu, 4 Sep 2003 17:40:45 -0300 (ADT) Received: from varsoon.wireboard.com (www.wireboard.com [216.151.155.101]) by svr1.postgresql.org (Postfix) with ESMTP id ECDBFD1B897 for ; Thu, 4 Sep 2003 17:40:41 -0300 (ADT) Received: from doug by varsoon.wireboard.com with local (Exim 3.35 #1) id 19v0uF-0000iA-00; Thu, 04 Sep 2003 16:40:39 -0400 To: =?iso-8859-1?q?Bj=F8rn?= T Johansen Cc: pgsql-general@postgresql.org Subject: Re: Backup? References: <1062703912.28376.31.camel@pennywise.havleik.no> From: Doug McNaught Date: 04 Sep 2003 16:40:39 -0400 In-Reply-To: =?iso-8859-1?q?Bj=F8rn?= T Johansen's message of "Thu, 04 Sep 2003 21:31:52 +0200" Message-ID: Lines: 10 User-Agent: Gnus/5.0806 (Gnus v5.8.6) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/393 X-Sequence-Number: 48615 Bj=F8rn 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. -Doug