Hello,
i have a "new" machine with following problem:
postgres-7.4.13[7874]: [457-1] ERROR: could not open segment 1 of relation
"data_server_id_idx" (target block 791807): No such file or directory
I my point of view it seems the same error as:
http://archives.postgresql.org/pgsql-admin/2006-07/msg00028.phphttp://archives.postgresql.org/pgsql-admin/2006-07/msg00103.php
The server is an HP DL 380 G4 with Battery Backup write cache.
I am doing a lot of inserts. (Linux + Postgresql 7.4.13)
I works correctly on an other server (Linux + Postgresl 7.4.10 , HP DL 380
G3 without Battery Backup Write Cache).
Linux + Postgresql 7.4.10 + HP DL 380 G3 without Battery Backup Write Cache
it takes about 4 hours
Linux + Postgresql 7.4.13 + HP DL 380 G4 with Battery Backup Write Cache it
takes about 15 minutes
Amount of RAM is the same (4 GB ) both have ext3 Filesystems
What could be the reason ? Postgresql 7.4.13 ? Configuration ? Linux Kernel
(2.4.28 vs. 2.4.32) ? Backup Write Cache ? Hardware ?
The first time it works correctly. Next day ist doesnt work.
Any help is appreciated.
regrads,
-Franz
