Re: Backup of users and groups?

My first line should have been pg_dumpall, at any rate, the command tom
is referring to is

pg_dumpall --globals_only

make sure you do this before you upgrade.

Dave
On Wed, 2004-03-10 at 11:21, Tom Lane wrote:
> Dave Cramer <pg(at)fastcrypt(dot)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
>
--
Dave Cramer
519 939 0336
ICQ # 14675561