>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 database in a given cluster, and also *preserves cluster-wide data such as role and tablespace definition*s. hence if you want to take backup for entire cluster then you can directly use pg_dumpall. or if you have any specific need then you can use pg_dump and manually preserve/delete other database objects . ----- Greetings, Samrat Revagade, NTT-DATA-OSS Center (Pune) -- View this message in context: http://postgresql.1045698.n5.nabble.com/Restore-after-using-pg-dumpall-tp5765452p5765716.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
