Re: [GENERAL] Error migrating from 7.4.3 to 8.0.3

2005-09-26 Thread Raj Gupta
This is a stock Mac OS 10.3 (Panther). Has anyone else seen this problem with 8.0.3 on Panther? According to the INSTALL file 10.3 should work fine, as reported by Andrew Rawnsley, cc'd on this message. Raj On Sep 26, 2005, at 12:23 PM, Tom Lane wrote: "Operation not permitted" during a wr

Re: [GENERAL] Error migrating from 7.4.3 to 8.0.3

2005-09-26 Thread Tom Lane
Raj Gupta <[EMAIL PROTECTED]> writes: > Postgresql 7.4 runs fine, and creates the index, so I would be > surprised if this is a hardware error? "Operation not permitted" during a write() is not very sensible; the kernel should have complained when the file was open()'d if there were permission is

Re: [GENERAL] Error migrating from 7.4.3 to 8.0.3

2005-09-26 Thread Raj Gupta
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, 200

Re: [GENERAL] Error migrating from 7.4.3 to 8.0.3

2005-09-26 Thread Raj Gupta
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

Re: [GENERAL] Error migrating from 7.4.3 to 8.0.3

2005-09-26 Thread Vivek Khera
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 behavi

Re: [GENERAL] Error migrating from 7.4.3 to 8.0.3

2005-09-26 Thread Poul Møller Hansen
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

[GENERAL] Error migrating from 7.4.3 to 8.0.3

2005-09-26 Thread Raj Gupta
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