Re: Copy Users?

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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, September 17, 2002 5:29 PM
To: James Hall
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Copy Users?

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