Postgres Pro
Downloads
Home   >   mailing lists

Re: how can i migrate just the users from one db to a new one - Mailing list pgsql-general

From Adrian Klaver
Subject Re: how can i migrate just the users from one db to a new one
Date
Msg-id 200903310701.00333.aklaver@comcast.net
Whole thread Raw
In response to how can i migrate just the users from one db to a new one  (Reid Thompson <reid.thompson@ateb.com>)
List pgsql-general
Tree view 
On Tuesday 31 March 2009 6:44:52 am Reid Thompson wrote:
> I've a DB and I want to migrate the users to a new empty DB.  How do I
> dump/reload just the users?
>
> Thanks,
> reid

pg_dumpall -g

From:
http://www.postgresql.org/docs/8.3/interactive/app-pg-dumpall.html

-g
--globals-only

    Dump only global objects (roles and tablespaces), no databases.

--
Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: SHARMILA JOTHIRAJAH
Date:
Subject: Space for pg_dump
Next
From: Scott Marlowe
Date:
Subject: Re: Server Performance