Hello, Ever since I migrated to a seperate PostgreSQL server, I've had various issues with dying NAV processes/daemons. The most common one is this error, appearing in servicemon.log after enabling DEBUG in the nav.conf file: FROM serviceproperty order BY serviceid [2008-10-08 12:38:58] servicemon.py:__init__:61 [Notice] Setting checkinterval=60 [2008-10-08 12:38:58] servicemon.py:__init__:63 [Notice] Reading database config [2008-10-08 12:38:58] servicemon.py:__init__:64 [Notice] Setting up runqueue [2008-10-08 12:38:58] RunQueue.py:__init__:98 [Notice] Setting maxthreads=20 [2008-10-08 12:38:58] RunQueue.py:__init__:100 [Notice] Setting maxRunCount=50 [2008-10-08 12:38:58] db.py:cursor:85 [Critical] Could not get cursor. Trying to reconnect... [2008-10-08 12:38:58] db.py:connect:72 [Notice] Successfully (re)connected to NAVdb [2008-10-08 12:38:58] db.py:query:108 [Debug] Executing: SELECT serviceid, property, value FROM serviceproperty order BY serviced I even had the servicemon developer over at my office, and he couldn't really tell why I was getting this error as he was able to grab the cursor when issuing it from a python shell. I've made some postgres.conf tweaks to allow harder work, as I have a quite big NAV database. Here are the changes I've made: <snip> work_mem = 98088 maintenance_work_mem = 131072 shared_buffers = 20000 vacuum_cost_delay = 50 checkpoint_segments = 20 checkpoint_timeout = 900 stats_start_collector = on stats_row_level = on max_fsm_pages = 500000 max_fsm_relations = 2000 wal_buffers = 512 max_locks_per_transaction = 512 </snip> Even though I've made these changes, I still seem to get: LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection LOG: unexpected EOF on client connection .. in my postgresql server logs... The PostgreSQL server itself is a Quad core CPU box with 8GB of ram, and should not be overloaded in any way. Load is ~0.10 at all times. Any ideas why my PostgreSQL server keeps rejecting cursors and giving me these EOF errors? Any help appreicated ------------------------------------------------------ Vidar Stokkenes Konsulent Nettverk Seksjon for nettverk og telekom HN IKT - Tromsø Tlf: 76 16 61 87 / 77 66 99 55 Mobil: 95 87 99 42 e-post: vidar.stokkenes@hn-ikt.no<mailto:vidar.stokkenes@hn-ikt.no> [cid:image001.png@01C92945.5BD3A8D0]