Re: Copy Users? - Mailing list pgsql-general

From Tom Lane
Subject Re: Copy Users?
Date
Msg-id 11678.1032301738@sss.pgh.pa.us
Whole thread Raw
In response to Copy Users?  (James Hall <James.Hall@RadioShack.com>)
List pgsql-general
James Hall <James.Hall@RadioShack.com> writes:
> Is there anyway to transfer the pg_user/pg_shadow data from one to database
> to another without a dumpall?

pg_dumpall has a switch to just dump the user/group info, and not the
databases.  Seems like that will do what you want.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] PGXLOG variable worthwhile?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: find overlapping address ranges