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