Обсуждение: 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