Thread: Taking backup of login roles in postgresql 8.2
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
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@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954