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
Any and all suggestions are greatly appreciated!
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2000-08-01 21:45:12|
|Subject: Re: copying pg_user? |
|Previous:||From: Dave_Pfaltzgraff||Date: 2000-08-01 17:50:43|
|Subject: Re: NOVICE - Wildcard query|