On Mon, Jul 29, 2013 at 6:49 PM, Asmus Reinhard <Reinhard.Asmus@xxxxxxxxxxxxxx> wrote:
Hallo,
between
pg_dumpall > alldb.sql (store)
According above command,you are taking all databases dump in plain text format which are available in PostgreSQL cluster running on 5432 port number.
and
psql –f alldb.sql postgres (restore)
is it necessary to drop existing objects (for example roles, …) ?
According to above command,Restoring plain text dumpfile into same PostgreSQL cluster running on 5432 port number.
If my assumptions are correct then you should drop existing database objects.
Thanks & Regards
Raghu Ram
