Re: I/O error on data file, can't run backup - Mailing list pgsql-general

From Tom Lane
Subject Re: I/O error on data file, can't run backup
Date
Msg-id 26013.1317847309@sss.pgh.pa.us
Whole thread Raw
In response to Re: I/O error on data file, can't run backup  (Leif Biberg Kristensen <leif@solumslekt.org>)
Responses Re: I/O error on data file, can't run backup  (Leif Biberg Kristensen <leif@solumslekt.org>)
List pgsql-general
Leif Biberg Kristensen <leif@solumslekt.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

pgsql-general by date:

Previous
From: Henry Drexler
Date:
Subject: Re: Analytic type functionality, matching patters in a column then increment an integer
Next
From: Leif Biberg Kristensen
Date:
Subject: Re: I/O error on data file, can't run backup