Re: Error migrating from 7.4.3 to 8.0.3 - Mailing list pgsql-general

From Raj Gupta
Subject Re: Error migrating from 7.4.3 to 8.0.3
Date
Msg-id 2fd3fc20b8feea6d934cf22244cc05f7@zeesource.net
Whole thread Raw
In response to Re: Error migrating from 7.4.3 to 8.0.3  (Vivek Khera <vivek@khera.org>)
Responses Re: Error migrating from 7.4.3 to 8.0.3
List pgsql-general
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


pgsql-general by date:

Previous
From: Raj Gupta
Date:
Subject: Re: Error migrating from 7.4.3 to 8.0.3
Next
From: Jan Wieck
Date:
Subject: Re: Replicating new sequences