|
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@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On
Behalf Of Gauthier, Dave 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 |
