Re: [ADMIN] Restore after using pg_dumpall

2013-07-31 Thread Samrat Revagade
>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. I think it is not necessary. pg_dumpall supports dumping of the entire contents of a database cluster, It backs up each databas

Re: [ADMIN] Restore after using pg_dumpall

2013-07-29 Thread raghu ram
On Mon, Jul 29, 2013 at 6:49 PM, Asmus Reinhard < reinhard.as...@spdfraktion.de> 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 Pos