Date: Fri, 23 Mar 2018 17:04:55 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Akshay Ballarpure <akshay.ballarpure@tcs.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: DB corruption
Message-ID: <20180323080455.GC7070@paquier.xyz>
References: 
 <OF94BA8A8F.1EB42658-ON65258259.002B6813-65258259.002BCA1B@tcs.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="IMjqdzrDRly81ofr"
Content-Disposition: inline
In-Reply-To: 
 <OF94BA8A8F.1EB42658-ON65258259.002B6813-65258259.002BCA1B@tcs.com>
Precedence: bulk


--IMjqdzrDRly81ofr
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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=20
> 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=20
> confidential or privileged information. If you are=20
> not the intended recipient, any dissemination, use,=20
> review, distribution, printing or copying of the=20
> information contained in this e-mail message=20
> and/or attachments to it are strictly prohibited. If=20
> you have received this communication in error,=20
> please notify us by reply e-mail or telephone and=20
> immediately and permanently delete the message=20
> and any attachments. Thank you

This is a public mailing list.
--
Michael

--IMjqdzrDRly81ofr
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlq0tScACgkQnvQgOdby
QH1sKA/9GnlbFWR+t8BGgDSMUHuA6gtw6JEqNQ3jYwDvBw4gaAEAFaoMQ3Vuhlsv
p9DOGy30SUe4TXhWv7nM3WLwxMurdaSsIUqBbYJajfwRbMlx+ruB3MxKECQ5Jdsb
KgPA6lnhPQxhHyww5jUnmy3M69nFJdrmq8rMabjZsYzIX7tafZHWXlLVrOmP/2uA
UOjD9FD6nNem4uF2dISX7KYdNuGnKGynhhqv+1f4/L4bPg58adYvw/GfvjCpkuQx
EF8AuhPNysgRPAVtdaQ/q55tcFIeB2gz4ywk7P96f3a9S4sN2zz1s1iqwCon5uTX
6SjKL2Ote/R/N7v8by/GI3vX++WVqRdM0UFOuFZWzEjiakETpkncHnyhitvy2Cys
prdMQ4MMYOTZ01fBuaoTzX/+2yFfTdCAbFltgZaIMACiMvijerO50HFfxZRjiPle
wSddHZJBMjafJOoHYb+zaz0Dz9Zc9/MfHJQkcju2psli7dOGR21HFvV0z16nYHmG
Rtf0YZep8ZuxEPUE7cQy2drfvdW0LtJ+0jX9PnFfkb9ni/ZbkeCieuxWo8q10ziz
0Wg7A8J0yTHFN+NzE8xKOV9tYAXQsWMXRr/7nq5k0T0Kr4h7Y2g5JgY7uEhCruxr
9hjAwk86MGAi2L0bMikaqCHHl0cSLoId5+MoUCdnpbNDZLytdfU=
=2Plc
-----END PGP SIGNATURE-----

--IMjqdzrDRly81ofr--