Postgres Pro
Downloads
Home   >   mailing lists

Re: dumping and restoring user information. - Mailing list pgsql-general

From Michael Fuhr
Subject Re: dumping and restoring user information.
Date
Msg-id 20050201073031.GA54012@winnie.fuhr.org
Whole thread Raw
In response to dumping and restoring user information.  (Pritesh Shah <pritesh.krish@gmail.com>)
Responses Re: dumping and restoring user information.  (Pritesh Shah <pritesh.krish@gmail.com>)
List pgsql-general
Tree view 
On Tue, Feb 01, 2005 at 12:11:06AM -0700, Pritesh Shah wrote:
>
> Is there any way of copying/dumping/restoring the user and group
> information and permissions from the old machine to the new one so
> that i do not have to do a createuser everytime??

You can dump just users and groups with "pg_dumpall --globals-only"
(or -g).

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Pritesh Shah
Date:
Subject: dumping and restoring user information.
Next
From: sid tow
Date:
Subject: Locking of auto generated sequence