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 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
