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 [EMAIL PROTECTED]) > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
