Re: Missing data frrom a shutdown

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