Taking backup of login roles in postgresql 8.2

------=_Part_10071_26318502.1193280817986
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_10071_26318502.1193280817986
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


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



------=_Part_10071_26318502.1193280817986--

Re: Taking backup of login roles in postgresql 8.2

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