Re: howto restore from pg_dumpall - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: howto restore from pg_dumpall
Date
Msg-id 200803162305.45936.peter_e@gmx.net
Whole thread Raw
In response to howto restore from pg_dumpall  ("Marc Fromm" <Marc.Fromm@wwu.edu>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: "Marc Fromm"
Date:
Subject: howto restore from pg_dumpall
Next
From: "Rommel the iCeMAn"
Date:
Subject: pgAdmin Crashes After Changing Timezone Setting