Where are roles stored in a cluster, and how do I dump them?
I did a pg_dump of a db and then loaded it into a different cluster, but I get a lot of these errors:
psql:mydump.sql:3621: ERROR: role "myrole" does not exist
So apparently the dump of my db does not include roles. I tried dumping the 'postgres' db, but I don't see the roles there either.
Do I need to use
pg_dumpall --roles-only ?
Postgresql versions 8.4.8 and 9.1.4 OS: Ubuntu 11.04 Natty