Skip site navigation (1) Skip section navigation (2)

Re: Taking backup of login roles in postgresql 8.2

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: arun <arunpjohny(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Taking backup of login roles in postgresql 8.2
Date: 2007-10-25 03:00:17
Message-ID: Pine.LNX.4.64.0710241959220.29776@discord.home.frostconsultingllc.com (view raw or flat)
Thread:
Lists: 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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954

In response to

pgsql-admin by date

Next:From: Scott MarloweDate: 2007-10-25 03:18:24
Subject: Re: l need help
Previous:From: arunDate: 2007-10-25 02:53:37
Subject: Taking backup of login roles in postgresql 8.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group