Re: Copy Users?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Hall <James(dot)Hall(at)RadioShack(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Copy Users?
Date: 2002-09-17 22:28:58
Message-ID: 11678.1032301738@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

James Hall <James(dot)Hall(at)RadioShack(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rod Taylor 2002-09-17 22:34:08 Re: PGXLOG variable worthwhile?
Previous Message Bruce Momjian 2002-09-17 22:22:47 Re: [HACKERS] PGXLOG variable worthwhile?