Missing data frrom a shutdown

Поиск
Список
Период
Сортировка
От Jorge Sauma
Тема Missing data frrom a shutdown
Дата
Msg-id 3DD4781B.1040206@its.co.cr
обсуждение исходный текст
Ответы Re: Missing data frrom a shutdown  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-admin
Hi,


Yesterday we suffered a power cut in our office, so the postgresql
server dies (the UPS didn't function properly). When the power was
restablished  the service started Ok, but we realize we have lost the
records from the last hour. We hope this records are in the logs
(pg_xlog or pg_clog) and we want to know if there's any way to recover
this data.
In the documentation we have found that this recovery is performed
automatically, but this didn't happen.
Thanks in advance for any help

Best regards,

PAviles

..Please answer to my e-mail address since I am not subscribed to the list.



В списке pgsql-admin по дате отправления:

Предыдущее
От: Jodi Kanter
Дата:
Сообщение: table locking?
Следующее
От: Andrés Ruz Salinas
Дата:
Сообщение: More one BDD