Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id EF2F12E02DA for ; Sat, 26 Jan 2008 14:50:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 64379-01 for ; Sat, 26 Jan 2008 14:50:12 -0400 (AST) Received: from mailsrv1.zmi.at (mailsrv1.zmi.at [212.69.162.198]) by postgresql.org (Postfix) with ESMTP id 84A962E0151 for ; Sat, 26 Jan 2008 14:50:25 -0400 (AST) Received: from laptopnav1 (M4052P013.adsl.highway.telekom.at [91.113.26.109]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (Client did not present a certificate) by mailsrv1.zmi.at (Postfix) with ESMTP id E912BBD5 for ; Sat, 26 Jan 2008 19:50:21 +0100 (CET) From: "Michael Monnerie" To: Subject: Syslog to postgresql - need peaks of 5.000/s Date: Sat, 26 Jan 2008 19:50:17 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 Thread-Index: AchgTEnyu7uWuThzS7i4vtNhBU5dCg== Message-Id: <20080126185021.E912BBD5@mailsrv1.zmi.at> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200801/258 X-Sequence-Number: 28032 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": http://ben.muppethouse.com/SYSLOG-DOC.html http://www.kdough.net/docs/syslog_postgresql/ But according to syslog, they will release the "direct syslog to postgresql" feature soon: http://www.balabit.com/network-security/syslog-ng/ 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 it-management.at 0676 846914 666