[dspam-users] postgresql and dspam

From: James Andrewartha <jamesa@daa.com.au>
Date: Mon Aug 01 2005 - 23:23:48 EDT

Hi,

I'm using postgres as the backend for dspam, and I'm currently trying to
tune it. When I restarted postgresql, I got a lot of:

Aug 2 11:11:21 quoll dspam[9702]: FATAL: the database system is shutting down
Aug 2 11:11:21 quoll dspam[9702]: connection pointer is NULL
Aug 2 11:11:21 quoll dspam[9702]: process_message returned error -2.
dropping message.

Does this mean dspam dropped those emails into the void, never to be delivered?

Also, my system is doing something like 500 disk transactions a second,
which is obviously stupid when it's only transferring 2MB/s. Does anyone
have any ideas on what might be causing this disk load? The server is a
proliant DL360 G4 with 1GB ram, dual 3.4GHz xeons and two seagate 7200.7
160GB sata drives in raid 1 (breaking the raid makes no difference).

Thanks,

-- 
James Andrewartha
Systems Administrator
Data Analysis Australia Pty Ltd
Received on Mon Aug 1 23:24:48 2005

This archive was generated by hypermail 2.1.8 : Thu Sep 29 2005 - 13:51:28 EDT