Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id AF5B82E2F89 for ; Thu, 29 Nov 2007 10:46:50 -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 34585-04-3 for ; Thu, 29 Nov 2007 10:46:36 -0400 (AST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.227]) by postgresql.org (Postfix) with ESMTP id 39BF62E0081 for ; Thu, 29 Nov 2007 10:46:42 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id l8so1405184nzf for ; Thu, 29 Nov 2007 06:46:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=5LyC5q5HNYjxO848F+YGNZ6imn468w1m+MBTU8GrdP4=; b=L51kKqDECFHo3iCHQwJsrff5QLh4N/wx7o25wkpGJdpq7LsO/dwUvRLfZGUt2M6XZRit6/PjZFHDLi8UQq/258xXzO0u+UzWlRIimAxq5dwNN8Gv55mRjE+PaHLBiTIAG2hWaLHfqLQxzkhK7W+7SI1deYa7G87fA31GMmhBWiY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=xahIbH4sIOmd+/RMEfzHSY15Zv+4zuP0BHqRiHNl+6T5fAnB0QXgRplK9cFll9u9aedyMd1aOQXiEsbhZrITHYveFrcBErvxeMhR1lMGi12tkhyMfJMx/DBNiYr1Kk2o15Z+JqdnddZITZ7aGGGUKFS4yrtHsldBGWLl0n1Q/TE= Received: by 10.142.171.6 with SMTP id t6mr802225wfe.1196347600348; Thu, 29 Nov 2007 06:46:40 -0800 (PST) Received: by 10.143.35.10 with HTTP; Thu, 29 Nov 2007 06:46:40 -0800 (PST) Message-ID: Date: Thu, 29 Nov 2007 08:46:40 -0600 From: "Jeff Larsen" To: pgsql-admin@postgresql.org Subject: Re: Enable Syslog on Postgres In-Reply-To: <6ADFAE1B098BCB45AAEF0147A830DD2A50AB4E@301081ANEX2.global.avaya.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <6ADFAE1B098BCB45AAEF0147A830DD2A50AB4E@301081ANEX2.global.avaya.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/241 X-Sequence-Number: 27484 > I have installed Postgres 8.2.5 on windows xp machine using the windows > installer. I am trying to enable syslogs on Postgres so that all Postgress > logs should be forwarded Syslog server. I have installed Syslog server > WinSyslog on the same machine. > > I have modified 'log_destination' parameter value in postgresql.conf to > 'syslog'. However, the database server fails to start and print following > error message: > > FATAL: invalid value for parameter "log_destination": "syslog" Well, the PG docs don't exactly say that syslog is not supported on Windows, but since syslog is not native to windows, I would guess that it is not supported in that situation. However, PG does support 'eventlog' on windows systems. Someone please correct me if my assumptions are wrong. > Also, I want to know how can I forward logs to a syslog server installed on > a machine different from database server's machine. Local services do not typically send syslog messages directly to remote syslogs, but, if you are on Linux/Unix you can configure the local syslog daemon to forward certain things to another syslog server. For your situation, perhaps send PG logs to eventlog, then look for Windows software to forward eventlog to a remote syslog. I know something like that exists, but I've never actually used it. Better yet, if your XP box has the resources, install the free VMware Server and run PG in a Linux virtual machine. Jeff