Re: pg_dump and roles

["Peter Steinheuser" <peter.steinheuser@xxxxxxxxxxxxxxxx>]

use pg_dumpall -g

On Fri, Oct 3, 2008 at 1:35 PM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
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@xxxxxxxxxxxxxxxx

http://www.enterprisedb.com
Built on open source. Compatible with Oracle®.