Re: Error migrating from 7.4.3 to 8.0.3

Raj Gupta wrote:
> Hi,
>
>  We are trying to migrate our database from 7.4.3 of Postgresql to 8.0.3.
>
>  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?
>

Have you dumped and restored the database ?
The structure of the two major versions is not compatible.

Poul