From: Peter Steinheuser <peter.steinheuser@enterprisedb.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump and roles
Date: Fri, 3 Oct 2008 13:44:13 -0400
Message-ID: <c30da9e30810031044o3f11021ar5dec933fbf2d51e8@mail.gmail.com> (raw)
In-Reply-To: <20081003173550.GE3817@alvh.no-ip.org>
References: <4k6ce45tvg8aqhnol6s8n6s3sn41bdc7q1@4ax.com>
<20081003173550.GE3817@alvh.no-ip.org>
use pg_dumpall -g
On Fri, Oct 3, 2008 at 1:35 PM, Alvaro Herrera
<alvherre@commandprompt.com>wrote:
> Julie Warden wrote:
>
> > Is there a method to dump just the roles from a database, or otherwise
> > select them, so I can build a script to reload the roles? Otherwise, I
> > guess I'll just read the tables for each database and build the
> > security script from that.
>
> Roles are not per-database; they are global objects. You can get a dump
> of all the roles with pg_dumpall -g.
>
> If you really need to filter out roles per database, my best suggestion
> is to filter a global role dump them with the pg_shdepend catalog for
> each database.
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
--
Peter Steinheuser
EnterpriseDB Corporation
499 Thornall Street
2nd Floor
Edison, NJ 08837
+1.732.331.1378 Office
+1.908.419.4220 Cell
+1.732.331.1301 Fax
peter.steinheuser@enterprisedb.com
http://www.enterprisedb.com
Built on open source. Compatible with Oracle(R).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: peter.steinheuser@enterprisedb.com, alvherre@commandprompt.com
Subject: Re: pg_dump and roles
In-Reply-To: <c30da9e30810031044o3f11021ar5dec933fbf2d51e8@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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