AW: Problems with base and postgresql

["Lieker Heinrich" <hlieker () dohle com>]

What do you mean? 
This?
"postmaster -i -D /var/lib/pgsql/data"

-----Ursprüngliche Nachricht-----
Von: Alejandro Flores [mailto:alejandrorflores () gmail com] 
Gesendet: Mittwoch, 30. März 2005 13:42
An: Lieker Heinrich
Cc: snort-users () lists sourceforge net
Betreff: Re: [Snort-users] Problems with base and postgresql


Hey,

> Still got problems with my BASE. I'm running Snort 2.3 with BASE 1.0.2 
> on a PostgreSQL 7.4.3 server. Snort is producing some alarms, but not 
> too many. Not always but often the server has a load of 99,9% because 
> of postmaster doing some INSERTS etc. The same is happening, when I'm 
> doing some queries with BASE. The system needs plenty of time to show 
> me the results. Do you have any ideas, why this happens? I have 
> already read some instructions how to tune my database with indexes 
> etc. But I don't exactly know, how I could do this. Can you help me?

Could you post here the startup line of your postgresql? What options are you using?

Regards,
Alejandro Flores


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_ide95&alloc_id396&op=click
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users