Skip site navigation (1) Skip section navigation (2)

Re: Error migrating from 7.4.3 to 8.0.3

From: Raj Gupta <gupta(at)zeesource(dot)net>
To: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error migrating from 7.4.3 to 8.0.3
Date: 2005-09-26 17:37:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Yes, I followed the procedure for dumping and restoring binary data (to 
include large objects).

It creates all the tables, etc. fine, and all the other indices are 
created. It's just this one index that it gives me a problem.

The problem also happens if I manually try to create the same index on 
that table. Otherwise, everything else seems to be okay.


On Sep 26, 2005, at 10:09 AM, Poul Møller Hansen wrote:

> 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?

In response to

pgsql-general by date

Next:From: Oleg BartunovDate: 2005-09-26 17:48:37
Subject: Re: Slow search.. quite clueless
Previous:From: John DeSoiDate: 2005-09-26 17:33:29
Subject: Re: Data Entry Tool for PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group