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 60FB1D1B4E5
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed, 23 Jun 2004 10:34:15 -0300 (ADT)
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 02997-08
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Wed, 23 Jun 2004 13:34:11 +0000 (GMT)
Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in
	[61.0.0.45])
	by svr1.postgresql.org (Postfix) with ESMTP id DF005D1B1C9
	for <pgsql-admin@postgresql.org>; Wed, 23 Jun 2004 10:34:03 -0300 (ADT)
Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by
	ndl1mr1-a-fixed.sancharnet.in
	(iPlanet Messaging Server 5.2 HotFix 1.27 (built May 12 2004))
	id <0HZR00G01JTP1M@ndl1mr1-a-fixed.sancharnet.in>
	(original mail from sank89@sancharnet.in) for
	pgsql-admin@postgresql.org; Wed, 23 Jun 2004 19:03:17 +0530 (IST)
Received: from [61.0.94.206] by ndl1mr1-a-fixed.sancharnet.in
	(iPlanet Messaging Server 5.2 HotFix 1.27 (built May 12 2004))
	with ESMTPA id <0HZR00368KBAFI@ndl1mr1-a-fixed.sancharnet.in>; Wed,
	23 Jun 2004 19:03:12 +0530 (IST)
Date: Wed, 23 Jun 2004 18:57:57 +0530
From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
	<sank89@sancharnet.in>
Subject: Re: Backup / Restore
In-reply-to: <20040623114034.29844.qmail@web40705.mail.yahoo.com>
To: "Eduardo S. Fontanetti" <dufuzzy@yahoo.com.br>
Cc: pgsql-admin@postgresql.org
Reply-To: aspire420@hotpop.com
Message-id: <40D9855D.60804@sancharnet.in>
Organization: Sai Hertz And Control Systems Pvt Ltd
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=us-ascii
Content-transfer-encoding: 7BIT
X-Accept-Language: en-us, en
User-Agent: Mozilla Thunderbird 0.7 (Windows/20040616)
References: <20040623114034.29844.qmail@web40705.mail.yahoo.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0
	tests=FROM_ENDS_IN_NUMS
X-Spam-Level: 
X-Archive-Number: 200406/305
X-Sequence-Number: 13965

Dear Eduardo ,

>What is the most recommended way to backup a
>PostgreSQL database?
>
>  
>
pg_dump --disable-triggers -U <user_name> -a -d -b -D -Fc -Z 9 -f 
<filername.tar.gz> <dbname>
+
A file system backup could be done but for this you will have to 
shutdown PostgreSQL server
before filesystem backup is done

>And to restore it? 
>  
>
pg_restore --disable-triggers -U <user_name> -d <dbname> 
<backupfilename.tar.gz>
IN case of Filesystem backup just stop PostgreSQL and replace the Dumped 
or Tared file of the
filesystem

Links
http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=x17860%2ehtm
And ofcource the PostgreSQL documentation itself

-- 
Best Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com [Soon http://www.saihertz.com]
Yahoo  IM: coeb_college[ a t ]yahoo.com