Restore after pg_dumpall - Mailing list pgsql-admin

From Asmus Reinhard
Subject Restore after pg_dumpall
Date
Msg-id 6E551FFA49836D4290CA09616AE1CB9BB15A03@EX01.SPDFRAK.BLN
Whole thread Raw
List pgsql-admin

>pg_dumpall > alldb.sql (store)

>and

>psql -f alldb.sql postgres (restore)

>is it necessary to drop existing objects (for example roles, ...) ?

>Any help is appreciated.

 

Last days i’m looking tot he options of pg_dumpall and I think the answer of my question is using option –c.

 

Using this option pg_dumpall generates at first drop commands for existing objects …

pgsql-admin by date:

Previous
From: Samrat Revagade
Date:
Subject: Re: Restore after using pg_dumpall
Next
From: Jürgen Fuchsberger
Date:
Subject: Problem: pg_ctl does not not stop postgres properly even with immediate option