Transaction logs gone, how to restart? - Mailing list pgsql-admin

From Jeff Boes
Subject Transaction logs gone, how to restart?
Date
Msg-id c07416077e235c92391d3db782b6a34d@news.teranews.com
Whole thread Raw
Responses Re: Transaction logs gone, how to restart?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@qtm.net   |        --Elbert Hubbard (1856-1915), American author



pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: HIPAA
Next
From: Tom Lane
Date:
Subject: Re: Transaction logs gone, how to restart?