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