Re: ERROR: could not open file "base/125542/12631" Corruption? - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: ERROR: could not open file "base/125542/12631" Corruption?
Date
Msg-id 20131004175144.GY5235@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: ERROR: could not open file "base/125542/12631" Corruption?  (Alejandro Brust <alejandrob@pasteleros.org.ar>)
List pgsql-admin
Alejandro Brust escribió:

> U could try  some like "SET/ zero_damaged_pages = on"    and perform a
> vacuum-db and may be pg_dump

I don't think this is a good idea.  It might cause data loss.  In any
case it's unlikely to fix the reported problem.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


pgsql-admin by date:

Previous
From: Alejandro Brust
Date:
Subject: Re: ERROR: could not open file "base/125542/12631" Corruption?
Next
From: Mike Broers
Date:
Subject: Re: ERROR: could not open file "base/125542/12631" Corruption?