Re: how can i migrate just the users from one db to a new one

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org, reid(dot)thompson(at)ateb(dot)com
Subject: Re: how can i migrate just the users from one db to a new one
Date: 2009-03-31 14:01:00
Message-ID: 200903310701.00333.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)comcast(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurent Rahuel 2009-03-31 14:03:51 Triggers for a MPTT based table
Previous Message Tom Lane 2009-03-31 13:57:46 Re: [GENERAL] pgstattuple triggered checkpoint failure and database outage?