Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump - groups and users. - Mailing list pgsql-novice

From Tom Lane
Subject Re: pg_dump - groups and users.
Date
Msg-id 11622.1014048973@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump - groups and users.  (John Herreshoff <jkherr@centurytel.net>)
Responses Re: pg_dump - groups and users.
List pgsql-novice
Tree view 
John Herreshoff <jkherr@centurytel.net> writes:
> How does one cause pg_dump to save groups and users in the backup
> file?

Use pg_dumpall, instead.

Users and groups span databases, so it's not really appropriate to
save them in pg_dump, which backs up only one database ...

            regards, tom lane

pgsql-novice by date:

Previous
From: John Herreshoff
Date:
Subject: pg_dump - groups and users.
Next
From: Michael Klatt
Date:
Subject: Read-only attributes