Re: Copy Users? - Mailing list pgsql-general

From James Hall
Subject Re: Copy Users?
Date
Msg-id DD6FD0C9668DD311AA040008C7566E8A0E636AA4@ntmailc.tandy.com
Whole thread Raw
In response to Copy Users?  (James Hall <James.Hall@RadioShack.com>)
List pgsql-general
I am not able to use pg_dumpall, the system has crashed and I only have read
access to the harddrives. I was hoping there would be a couple of files I
could copy over to the new database and get the users back<?>.

Thanks,
-jim


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, September 17, 2002 5:29 PM
To: James Hall
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Copy Users?


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: Tom Lane
Date:
Subject: Re: [GENERAL] Still big problems with pg_dump!
Next
From: Wim
Date:
Subject: Re: [ADMIN] Still big problems with pg_dump!