Re: very concerning, tables hopped from one database to another

David Ford <david+cert(at)blue-labs(dot)org> writes:
> Summary. I had 8 databases, I created another one for 9. I started
> psql and created a table, created a user, and granted permissions. I
> then did a \z to check up on things. Lo and behold, I have 3/4 of the
> tables from another database moved into here! I disconnect, reconnect,
> yep, still there. I connect to the other database and those tables are
> missing. I'm absolutely positive that these tables were in 'hmzbook'
> before this. I triple checked and examined a dated pg_dump from a few
> days ago and 'hmzbook' was correct.

PG version?

There was a bug in a prerelease 7.0 or 7.1 (forget which) whereby the
buffer manager sometimes forgot to check the database ID of a dirty
block, but I've not heard of any such cases lately.

regards, tom lane