Arun, You have to use pg_dumpall with the --globals setting like so: pg_dumpall --globals > globals.sql or pass it through gzip first: pg_dumpall --globals | gzip > globals.sql.gz On Thu, 25 Oct 2007, arun wrote:
Hi all, I'm new to this forum. Can any one tell me how to take backup of login roles in postgresql. I know how to take database backup. It is giving me all the schemas in the selected database, but not creating the login roles required when restoring the database Thank you
-- Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
