Restore after using 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 using pg_dumpall
Date: 2013-07-29 13:19:30
Message-ID: 6E551FFA49836D4290CA09616AE1CB9BB14718@EX01.SPDFRAK.BLN
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hallo,

between

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message raghu ram 2013-07-29 13:33:47 Re: Restore after using pg_dumpall
Previous Message Manish Kediyal 2013-07-29 08:08:11 Re: Shell Script for Vacuum