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

From Pritesh Shah
Subject Re: dumping and restoring user information.
Date
Msg-id de6ea2a70502031356749b7bd6@mail.gmail.com
Whole thread Raw
In response to Re: dumping and restoring user information.  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Thanks, it worked.


On Tue, 1 Feb 2005 00:30:31 -0700, Michael Fuhr <mike@fuhr.org> wrote:
> 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: Karl Denninger
Date:
Subject: Re: Eeek! Major problem after reload with tsearch2
Next
From: Wes
Date:
Subject: Re: Indexed leading substring searches - worked, now