use pg_dumpall -g On Fri, Oct 3, 2008 at 1:35 PM, Alvaro Herrera <[EMAIL PROTECTED]>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 [EMAIL PROTECTED] http://www.enterprisedb.com Built on open source. Compatible with Oracle(R).
