Search Postgresql Archives

Re: Error migrating from 7.4.3 to 8.0.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux