Skip site navigation (1) Skip section navigation (2)

Re: Syslog to postgresql - need peaks of 5.000/s

From: Michael Monnerie <michael(dot)monnerie(at)it-management(dot)at>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Syslog to postgresql - need peaks of 5.000/s
Date: 2008-01-29 00:15:43
Message-ID: 200801290115.50295@zmi.at (view raw or flat)
Thread:
Lists: pgsql-admin
On Samstag, 26. Januar 2008 paul rivers wrote:
> Anyway, that's my experience with this, hope it helps.

Dear Paul, thanks a lot for the very detailed information. I'm more 
relaxed now as it seems to be possible to do everything I wanted, 
although I'm concerned that 5.000 inserted lines per second could be a 
problem. I'll just start with a server and then see it's limits and 
what more I need. 

BTW, this information could be very interesting for you. According to 
syslog, they will release the "direct syslog to postgresql"
feature soon:
http://www.balabit.com/network-security/syslog-ng/

You might not change the running process, but for a new implementation 
this could make things much easier.

mfg zmi
-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4

In response to

pgsql-admin by date

Next:From: Julio LeyvaDate: 2008-01-29 01:26:12
Subject: WAL files and heckpoints
Previous:From: Spiegelberg, GregDate: 2008-01-28 21:37:00
Subject: Re: Zen and art if WAL and dump file mainteance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group