pg_user pg_shadow out of sync

From: "Sandy Spence" <axs(at)aber(dot)ac(dot)uk>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_user pg_shadow out of sync
Date: 2007-05-02 10:55:51
Message-ID: 002401c78ca8$734effe0$520b3cc1@pc2axs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

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?

Cheers,

Sandy

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2007-05-02 12:59:40 Re: infinite blocking statements in 8.2.3
Previous Message Gabriele Bartolini 2007-05-02 10:05:33 VACUUM FULL ANALYSE hanging