pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTaking 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>
2007-10-25 03:00 ` Re: Taking backup of login roles in postgresql 8.2 Jeff Frost <jeff@frostconsultingllc.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 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>
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