From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-admin@postgresql.org
Cc: Marc Fromm <Marc.Fromm@wwu.edu>
Subject: Re: howto restore from pg_dumpall
Date: Sun, 16 Mar 2008 23:05:44 +0100
Message-ID: <200803162305.45936.peter_e@gmx.net> (raw)
In-Reply-To: <81FEAB8CDDC62B42B6E8AA258228BC88047417DA@EVS2.univ.dir.wwu.edu>
References: <81FEAB8CDDC62B42B6E8AA258228BC88047417DA@EVS2.univ.dir.wwu.edu>
Marc Fromm wrote:
> When I restore from a pg_dumpall file, I am required to peform the
> following steps or else all the records in the databses are duplicated. If
> I only empty the data/base folder I get al sorts of errors.
You may find the pg_dumpall --clean option useful, so the dump file is set up
in a way that cleans out its predecessor objects automatically. Otherwise
you will have to find your own to way clean up before restoring.
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: peter_e@gmx.net, Marc.Fromm@wwu.edu
Subject: Re: howto restore from pg_dumpall
In-Reply-To: <200803162305.45936.peter_e@gmx.net>
* 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