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 0A80ED1B96E
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Thu,  4 Sep 2003 20:48:32 +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 23358-05
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Thu,  4 Sep 2003 17:48:03 -0300 (ADT)
Received: from lorax.kciLink.com (lorax.kciLink.com [206.112.95.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 34A31D1B8EA
	for <pgsql-general@postgresql.org>;
	Thu,  4 Sep 2003 17:48:01 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by lorax.kciLink.com (Postfix) with ESMTP id 161493E0B
	for <pgsql-general@postgresql.org>;
	Thu,  4 Sep 2003 16:48:03 -0400 (EDT)
Received: from lorax.kciLink.com ([127.0.0.1])
	by localhost (lorax.kciLink.com [127.0.0.1]) (amavisd-new, port 10024)
	with LMTP id 39638-06-3 for <pgsql-general@postgresql.org>;
	Thu,  4 Sep 2003 16:47:52 -0400 (EDT)
Received: from lorax.kciLink.com (localhost [127.0.0.1])
	by lorax.kciLink.com (Postfix) with ESMTP id 8F0A93E07
	for <pgsql-general@postgresql.org>;
	Thu,  4 Sep 2003 16:47:52 -0400 (EDT)
Received: (from news@localhost)
	by lorax.kciLink.com (8.12.8p1/8.12.8/Submit) id h84Klqf6073824
	for pgsql-general@postgresql.org; Thu, 4 Sep 2003 16:47:52 -0400 (EDT)
To: pgsql-general@postgresql.org
Path: not-for-mail
From: Vivek Khera <khera@kcilink.com>
Newsgroups: ml.postgres.general
Subject: Re: Backup?
Date: Thu, 04 Sep 2003 16:47:52 -0400
Organization: Khera Communications, Inc., Rockville, MD
Lines: 22
Message-ID: <x74qzsi8lj.fsf@yertle.int.kciLink.com>
References: <1062703912.28376.31.camel@pennywise.havleik.no>
NNTP-Posting-Host: yertle.kcilink.com
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: lorax.kciLink.com 1062708472 55971 216.194.193.105 (4 Sep 2003
	20:47:52 GMT)
X-Complaints-To: daemon@kciLink.com
NNTP-Posting-Date: Thu, 4 Sep 2003 20:47:52 +0000 (UTC)
User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Portable Code,
	berkeley-unix)
Cancel-Lock: sha1:RR+O9eeZpDuSfWnI+4f85QGXyXU=
X-Virus-Scanned: by amavisd-new at kciLink.com
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/392
X-Sequence-Number: 48614

>>>>> "BTJ" == Bjørn T Johansen <Bj> writes:

BTJ> Should one use pg_dumpall to backup the database or is it more

yes, or pg_dump specific databases.

BTJ> practical to just copy the data directory?

this would do you no good, since the files are not necessarily in a
consistent state when you copy many of them.  ie, the copy is
non-atomic, and there is no guarantee that all data is flushed to
disk.

i don't even do a file system dump of my PG data partition because of
this.


-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/