From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Jorge Sauma <jsauma(at)its(dot)co(dot)cr> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Missing data frrom a shutdown |
Date: | 2002-11-16 03:03:32 |
Message-ID: | 200211160303.gAG33WR22268@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)org)
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah. | 2002-11-16 13:23:11 | Re: More one BDD |
Previous Message | Ragnar Kjørstad | 2002-11-16 02:10:32 | Re: [linux-lvm] PostgreSQL and file system level backup |