Tom Lane wrote:
> Gavin Sherry <swm@linuxworld.com.au> writes:
> > When I first brought it down, I attempted this, but forgot -O. I've just
> > done this, however, it connected fine. Moreover, a select * from
> > pg_shadow; returned results! I vacuumed and brought the database back
> > online -- everything fine.
>
> > Extremely strange =\.
>
> Did I read you correctly to say that you're still on 7.1?
>
> This episode should convince you to update to 7.1.3, pronto.
> We don't make dot-releases for amusement value.
>
> (No, I can't cite any particular bug that might've led to this.)
IIRC there was this cross DB shared buffer usage bug somewhere in 7.1, that used blocks from another DB
found by accident in the cache. So it all must have been a cache problem and the postmaster restart
fix^H^H^H made it disappear and lurk again.
That bug can corrupt the system catalogs of all your databases! Upgrade NOW!
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com