Re: Database OID xxxxx now seems to belong to "foo"

I tried vacuum pg_database, no luck. I shut down and restarted the DB
and it seems to have fixed the problem. Still, not sure why it happened
in the first place or how to prevent it in the future.

________________________________

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Gauthier, Dave
Sent: Tuesday, March 11, 2008 9:31 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Database OID xxxxx now seems to belong to "foo"

Hi:

Trying (and failing) to attach to my DBs. Getting...

database "foo_standby" has disappeared form pg_database

DETAIL: Database OID 2323523 now seems to belong to "foo"

I have 2 dbs... foo and foo_standby. Every midnight, I truncate
foo_standby and load it up with all the current data from mu various
sources. If that's successful, I then rename foo to foo_tmp, then
rename foo_standby to foo, then rename foo_tmp to foo_standby. This
results in a minimal "down time" of the foo database ebcause the renames
happen fast. And foo_standby is now my backup from the previous day,
something I can switch back to if something goes wrong with the new foo
db.

Anyway, "psql -l" does show my dbs. There are other dbs for other
projects and I can connect to those OK. I just can't connect to foo or
foo_standby.

Q: What might have caused this problem and how can I avoid/prevent it in
the future

Q: Can I salvage my foo and foo_standby DBs?

Thanks

-dave