Re: pg_user pg_shadow out of sync - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: pg_user pg_shadow out of sync
Date
Msg-id 20070502134802.GA12574@winnie.fuhr.org
Whole thread Raw
In response to pg_user pg_shadow out of sync  ("Sandy Spence" <axs@aber.ac.uk>)
List pgsql-admin
On Wed, May 02, 2007 at 11:55:51AM +0100, Sandy Spence wrote:
> Can any one tell me what I need to do to get this back on if I do a select
> on pg_user for a particular user and then do a select on users for the same
> user the expiry and valuntil columns are different?  How do I get these to
> match?

Could you post the exact queries you're running along with the
output?  What version of PostgreSQL are you using?

--
Michael Fuhr

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: infinite blocking statements in 8.2.3
Next
From: "dx k9"
Date:
Subject: reindexdb hangs