From: | Jeff Boes <jboes(at)nexcerpt(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Transaction logs gone, how to restart? |
Date: | 2004-03-09 13:46:19 |
Message-ID: | c07416077e235c92391d3db782b6a34d@news.teranews.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
We backed up our test server yesterday (Pg 7.4.1) as the first step in switching
from Red Hat 7 to Whitebox. However, we failed to back up the transaction and
commit logs. Now that the OS and database are back to where they were, we get
this message on attempting to restart:
LOG: could not open file "/usr/local/pgsql/data/pg_xlog/00000041000000EE" (log
file 65, segment 238): No such file or directory
(There are other problems that we are still working to correct, but this is the
one that I don't understand.)
--
~~~~~~~~~~~~~~~~| Genius may have its limitations, but stupidity is not
Jeff Boes | thus handicapped.
jboes(at)qtm(dot)net | --Elbert Hubbard (1856-1915), American author
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-03-09 15:51:06 | Re: Transaction logs gone, how to restart? |
Previous Message | Yauger, Joshua (Contractor) | 2004-03-09 13:32:49 | Cygwin - Cygnus for Windows - Linux based ported to Windows |