From: Eduardo S. Fontanetti <dufuzzy@yahoo.com.br>
To: pgsql-admin@postgresql.org
Subject: Backup / Restore
Date: Wed, 23 Jun 2004 08:40:34 -0300 (ART)
Message-ID: <20040623114034.29844.qmail@web40705.mail.yahoo.com> (raw)
What is the most recommended way to backup a
PostgreSQL database?
And to restore it?
I would like to get ALL the data and properties
possible, because if I have a problem, and I lost my
current database, I can just restore it, and will be
all exactly like was before.
What is the best way? pg_dump? If yes, what options I
need to use?
Thanks a lot!!
Eduardo S. Fontanetti
______________________________________________________________________
Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis!
http://br.info.mail.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: dufuzzy@yahoo.com.br
Subject: Re: Backup / Restore
In-Reply-To: <20040623114034.29844.qmail@web40705.mail.yahoo.com>
* 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