Re: pg_user pg_shadow out of sync

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Sandy Spence <axs(at)aber(dot)ac(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_user pg_shadow out of sync
Date: 2007-05-02 13:48:02
Message-ID: 20070502134802.GA12574@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message dx k9 2007-05-02 14:50:09 reindexdb hangs
Previous Message Alvaro Herrera 2007-05-02 12:59:40 Re: infinite blocking statements in 8.2.3