Skip site navigation (1) Skip section navigation (2)

copying pg_user?

From: James Hall <James(dot)Hall(at)RadioShack(dot)com>
To: pgsql-novice(at)hub(dot)org
Subject: copying pg_user?
Date: 2000-08-01 20:51:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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 LaneDate: 2000-08-01 21:45:12
Subject: Re: copying pg_user?
Previous:From: Dave_PfaltzgraffDate: 2000-08-01 17:50:43
Subject: Re: NOVICE - Wildcard query

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group