Transaction logs gone, how to restart?

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

Responses

Browse pgsql-admin by date

  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