Re: Error migrating from 7.4.3 to 8.0.3

From: Vivek Khera <vivek(at)khera(dot)org>
To: pgsql general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Error migrating from 7.4.3 to 8.0.3
Date: 2005-09-26 17:23:51
Message-ID: 420BD7E2-3B0F-4A74-9BB6-153841698C76@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Sep 26, 2005, at 12:43 PM, Raj Gupta wrote:

> While migrating a table, we got the following error:
>
> ERROR: could not write block 2830 of relation
> 1663/2276041/4965853: Operation not permitted
>
> This came when pg was trying to create an index on the relation.
> Has anyone seen this behavior before? Are we doing something wrong?
>

This is during the pg_restore step when loading your data into the
8.0.3 instance? it looks suspiciously like some sort of low-level
fault. Try running some hardware diags on your system.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2005-09-26 17:33:29 Re: Data Entry Tool for PostgreSQL
Previous Message Poul Møller Hansen 2005-09-26 17:09:13 Re: Error migrating from 7.4.3 to 8.0.3