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

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: Syslog to postgresql - need peaks of 5.000/s
Date: 2008-01-26 18:50:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Dear list,

I shall build up a central syslog server able to do 5.000 log lines per
second peak, 1.000 sustained. I found some pages describing current
syslog-ng with magic "log to file then insert":

But according to syslog, they will release the "direct syslog to postgresql"
feature soon:

Anyway, I'd like to know if anybody has a syslog-ng with postgresql that
does up to 5000 inserts/s, and what hardware I need for that. Of course,
some selects for statistical purposes must also be possible, so not only
writes here. Any ideas?

mfg zmi
Michael Monnerie
0676 846914 666 


pgsql-admin by date

Next:From: NUWAN LIYANAGEDate: 2008-01-26 21:06:18
Subject: Re: backup including symbolic links?
Previous:From: Tom LaneDate: 2008-01-26 18:10:49
Subject: Re: Recovering a database in danger of transaction wrap-around

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