Restore after pg_dumpall

From: Asmus Reinhard <Reinhard(dot)Asmus(at)spdfraktion(dot)de>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Restore after pg_dumpall
Date: 2013-07-31 07:14:51
Message-ID: 6E551FFA49836D4290CA09616AE1CB9BB15A03@EX01.SPDFRAK.BLN
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ...

Browse pgsql-admin by date

  From Date Subject
Next Message Jürgen Fuchsberger 2013-07-31 13:16:43 Problem: pg_ctl does not not stop postgres properly even with immediate option
Previous Message Samrat Revagade 2013-07-31 07:00:38 Re: Restore after using pg_dumpall