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


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to