Re: dumping and restoring user information.

From: Pritesh Shah <pritesh(dot)krish(at)gmail(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dumping and restoring user information.
Date: 2005-02-03 21:56:28
Message-ID: de6ea2a70502031356749b7bd6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks, it worked.

On Tue, 1 Feb 2005 00:30:31 -0700, Michael Fuhr <mike(at)fuhr(dot)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/
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wes 2005-02-03 22:14:23 Re: Indexed leading substring searches - worked, now
Previous Message Karl Denninger 2005-02-03 21:42:48 Re: Eeek! Major problem after reload with tsearch2