Re: I/O error on data file, can't run backup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: I/O error on data file, can't run backup
Date: 2011-10-05 20:41:49
Message-ID: 26013.1317847309@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Leif Biberg Kristensen <leif(at)solumslekt(dot)org> writes:
> I seemingly fixed the problem by stopping postgres and doing:
> balapapa 612249 # mv 11658 11658.old
> balapapa 612249 # mv 11658.old 11658

> And the backup magically works.

Wow, that is magic. I was going to suggest copying pg_opfamily from
template0, which would probably work (maybe requiring reindexing) as
long as you didn't have any non-core data types in use. But you
got lucky.

> I'm gonna move the data to another disk right now.

Good plan.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leif Biberg Kristensen 2011-10-05 21:48:07 Re: I/O error on data file, can't run backup
Previous Message Henry Drexler 2011-10-05 20:02:53 Re: Analytic type functionality, matching patters in a column then increment an integer