|
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 |
