pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_user pg_shadow out of sync
3+ messages / 3 participants
[nested] [flat]
* pg_user pg_shadow out of sync
@ 2007-05-02 10:55 Sandy Spence <axs@aber.ac.uk>
0 siblings, 2 replies; 3+ messages in thread
From: Sandy Spence @ 2007-05-02 10:55 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_user pg_shadow out of sync
@ 2007-05-02 13:48 Michael Fuhr <mike@fuhr.org>
parent: Sandy Spence <axs@aber.ac.uk>
1 sibling, 0 replies; 3+ messages in thread
From: Michael Fuhr @ 2007-05-02 13:48 UTC (permalink / raw)
To: Sandy Spence <axs@aber.ac.uk>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_user pg_shadow out of sync
@ 2007-05-03 05:18 Tom Lane <tgl@sss.pgh.pa.us>
parent: Sandy Spence <axs@aber.ac.uk>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2007-05-03 05:18 UTC (permalink / raw)
To: Sandy Spence <axs@aber.ac.uk>; +Cc: pgsql-admin
"Sandy Spence" <axs@aber.ac.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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-05-03 05:18 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-02 10:55 pg_user pg_shadow out of sync Sandy Spence <axs@aber.ac.uk>
2007-05-02 13:48 ` Michael Fuhr <mike@fuhr.org>
2007-05-03 05:18 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox