David Chapman <david(dot)luckychap(at)gmail(dot)com> writes:
> Can PG_dump create commands that will include restoring the users and groups
> after a fatal disk crash?
pg_dump doesn't do that; pg_dumpall does. This is because pg_dump is
meant to dump only one database in an installation, while users and
groups span the whole installation. So they should be dumped as part
of a whole-installation dump, ie, pg_dumpall.
BTW, please send list messages to pgsql-novice, not pgsql-novice-owner.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2005-12-31 20:27:51|
|Subject: Re: Restoring to a different tablespace |
|Previous:||From: Michael Avila||Date: 2005-12-31 19:59:52|
|Subject: Re: ecommerce solution|