Database OID xxxxx now seems to belong to "foo"

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Database OID xxxxx now seems to belong to "foo"
Date: 2008-03-11 13:31:20
Message-ID: 0836165E8EE50F40A3DD8F0D87137267185EC6@azsmsx421.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sathiya psql 2008-03-11 13:45:03 list user created triggers
Previous Message André Volpato 2008-03-11 13:07:19 Re: PostgreSQL and MOLAP ?