-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, How do I backup all the roles and ACLs that have permissions to a single database? pg_dumpall -g does not do the trick because it dumps all the roles from all the databases. I've read the system catalogs documentation [1], but I didn't figure how to relate the database name with the table names... So far I can get all the database names, owners oid and ACLs using: select oid,datname,datdba,datacl from pg_database; But how do I relate pg_database.oid with pg_class (to get table ACLs)? or maybe its related with other table that I'm missing? TIA! Best regards, Rui Lopes [1] http://www.postgresql.org/docs/8.2/static/catalogs.html -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHA9UHg6ss8INEYd4RAhGJAJ9gcuPY/VoIPUGnkB6QLEWaf6tsYACeOxul qqUTkoo1WewaLKDxJXSZfHE= =GLyA -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
