Missing data frrom a shutdown

Поиск
Список
Период
Сортировка
Искать

Missing data frrom a shutdown

От:
Jorge Sauma <jsauma@its.co.cr>
Дата:
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.


Re: Missing data frrom a shutdown

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:

This is very unusual.  Were you running with fsync off?  I can't imagine
what would cause this.  What version are you running.  As a guess, try
dropping and recreating the index on the table and see if the data
reappears.



---------------------------------------------------------------------------

Jorge Sauma wrote:
> 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.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
FAQ