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

Re: Send all postgres messages to a specific folder

From: Neal Clark <nclark(at)securescience(dot)net>
To: Leticia Larrosa <leticia(at)tesla(dot)cujae(dot)edu(dot)cu>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Send all postgres messages to a specific folder
Date: 2007-01-18 22:43:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I'm not sure how it looks on your system, but on mine (FreeBSD 6.1,  
PG 8.1 from ports), the default in postgresql.conf is to send  
everything to a number of syslog facilities with the ident 'postgres'.

Anyway, I haven't messed with any of these settings, and I get  
everything in messages, but you should be able to do this by adding a  
line like this to syslog.conf:

	postgres.*	/var/log/postgresql

I think that will send everything from postgre to that one file. As  
for splitting it up into multiple files, you'd have to  do stuff like

	postgres.error	/var/log/postgresql/errors
	postgres.fatal	/var/log/postgresql/fatal
	postgres.notice ... etc.

hope that helps,

On Jan 18, 2007, at 1:47 PM, Leticia Larrosa wrote:

> Hi
> In my ubuntu server I have two places where are logged the messages  
> from postgreSql. Some kind of messages are logged in /var/log/ 
> postgresql/postgresql-8.1-main.log and others messages are loggued  
> in "/var/log/messages".
> I want send all my messages to an specific folder (/var/log/ 
> postgresql/) and none of them to "/var/log/messages"
> How can I do that?
> Thanks in advanced.
> </L>

In response to

pgsql-novice by date

Next:From: John DeSoiDate: 2007-01-19 13:23:58
Subject: Re: Select Into help
Previous:From: Leticia LarrosaDate: 2007-01-18 21:47:57
Subject: Send all postgres messages to a specific folder

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