Re: Backup of users and groups?

Dave Cramer <pg@fastcrypt.com> writes:
> You should do a pg_dump all of your database(s) if you want to restore
> them on to a 7.4 instance.

> At a minimum, do a pg_dump -s db for the schema, I believe it will dump
> the users and groups.

No, pg_dump only dumps what is in a single database.  Users and groups
span all databases in a cluster, so they are outside the purview of
pg_dump.  You *must* use pg_dumpall to dump user and group info.

There is an option to pg_dumpall to dump only this info, and not invoke
pg_dump on each individual database as it normally would do.

            regards, tom lane