Re: ERROR: could not open file "base/125542/12631" Corruption?

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Alejandro Brust <alejandrob(at)pasteleros(dot)org(dot)ar>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ERROR: could not open file "base/125542/12631" Corruption?
Date: 2013-10-04 17:51:44
Message-ID: 20131004175144.GY5235@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Broers 2013-10-04 19:14:39 Re: ERROR: could not open file "base/125542/12631" Corruption?
Previous Message Alejandro Brust 2013-10-04 17:16:26 Re: ERROR: could not open file "base/125542/12631" Corruption?