Transaction logs gone, how to restart?

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема Transaction logs gone, how to restart?
Дата
Msg-id c07416077e235c92391d3db782b6a34d@news.teranews.com
обсуждение исходный текст
Ответы Re: Transaction logs gone, how to restart?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: HIPAA
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Transaction logs gone, how to restart?