Re: pg_user pg_shadow out of sync

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-03 05:18:59
Message-ID: 25267.1178169539@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Sandy Spence" <axs(at)aber(dot)ac(dot)uk> writes:
> 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?

It's pretty hard to see how pg_user could vary from pg_shadow, seeing
that the former is just a view of the latter. But what's this "users"
you mention ... is that just a typo, or some locally installed addition?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Markus 2007-05-03 05:33:32 Re: infinite blocking statements in 8.2.3
Previous Message Tom Lane 2007-05-02 22:25:03 Re: reindexdb hangs