| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Akshay Ballarpure <akshay(dot)ballarpure(at)tcs(dot)com> |
| Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: DB corruption |
| Date: | 2018-03-23 08:04:55 |
| Message-ID: | 20180323080455.GC7070@paquier.xyz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, Mar 23, 2018 at 01:29:35PM +0530, Akshay Ballarpure wrote:
> I have a query on DB corruption. Is there any way to recover from it
> without losing data ?
Corrupted pages which need to be zeroed in order to recover the rest is
data lost forever, except if you have a backup you can rollback to.
Please see here for some global instructions about how to deal with such
situations:
https://wiki.postgresql.org/wiki/Corruption
First take a deep breath, and take the time to read and understand it.
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
This is a public mailing list.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter | 2018-03-23 10:03:08 | Should from_collapse be switched off? (queries 10 times faster) |
| Previous Message | Akshay Ballarpure | 2018-03-23 07:59:35 | DB corruption |