copying pg_user? - Mailing list pgsql-novice

From James Hall
Subject copying pg_user?
Date
Msg-id DD6FD0C9668DD311AA040008C7566E8A0313E57E@ntmailc.tandy.com
Whole thread Raw
Responses Re: copying pg_user?
List pgsql-novice
Hello,

I have 2 PostgreSQL databases that [I thought] were identical. Today I
noticed that the query "select * from pg_user;" results in different results
from each database.

My question is what is the easiest/best/safest way to copy the pg_user file
from db to another? Can I simply copy the pg_user file from one db to the
other and restart the db, or should I use pg_dump on pg_user and import like
that?

Any and all suggestions are greatly appreciated!
TIA
-Jim

pgsql-novice by date:

Previous
From: Dave_Pfaltzgraff@patapsco.com
Date:
Subject: Re: NOVICE - Wildcard query
Next
From: Tom Lane
Date:
Subject: Re: copying pg_user?