From: V i s h a l Kashyap @ [Sai Hertz And Control Systems] <sank89@sancharnet.in>
To: Eduardo S. Fontanetti <dufuzzy@yahoo.com.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: Backup / Restore
Date: Wed, 23 Jun 2004 18:57:57 +0530
Message-ID: <40D9855D.60804@sancharnet.in> (raw)
In-Reply-To: <20040623114034.29844.qmail@web40705.mail.yahoo.com>
References: <20040623114034.29844.qmail@web40705.mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sank89@sancharnet.in, dufuzzy@yahoo.com.br
Subject: Re: Backup / Restore
In-Reply-To: <40D9855D.60804@sancharnet.in>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox