pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Taking backup of login roles in postgresql 8.2
2+ messages / 2 participants
[nested] [flat]

* Taking backup of login roles in postgresql 8.2
@ 2007-10-25 02:53  arun <arunpjohny@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: arun @ 2007-10-25 02:53 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Taking backup of login roles in postgresql 8.2
@ 2007-10-25 03:00  Jeff Frost <jeff@frostconsultingllc.com>
  parent: arun <arunpjohny@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Jeff Frost @ 2007-10-25 03:00 UTC (permalink / raw)
  To: arun <arunpjohny@gmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-10-25 03:00 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-10-25 02:53 Taking backup of login roles in postgresql 8.2 arun <arunpjohny@gmail.com>
2007-10-25 03:00 ` Jeff Frost <jeff@frostconsultingllc.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox