Re: Error migrating from 7.4.3 to 8.0.3

This is both while doing  a pg_restore and also when doing a 'create
index' command.

This is running on Mac OS X 10.3

Postgresql 7.4 runs fine, and creates the index, so I would be
surprised if this is a hardware error?

Raj


On Sep 26, 2005, at 10:23 AM, Vivek Khera wrote:

>
> 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.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend