Re: [GENERAL] Backup single database roles and ACLs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rui Lopes wrote: > 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. roles are part of the catalog/cluster

[GENERAL] Backup single database roles and ACLs

-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