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