pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.



view thread (2+ messages)

Message-ID: <200803162305.45936.peter_e@gmx.net>
Permalink:  ../200803162305.45936.peter_e@gmx.net/
Also on:    postgresql.org/message-id/200803162305.45936.peter_e@gmx.net

 · 

reply

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