Обсуждение: Send all postgres messages to a specific folder

Поиск
Список
Период
Сортировка

Send all postgres messages to a specific folder

От
"Leticia Larrosa"
Дата:

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>

 

Re: Send all postgres messages to a specific folder

От
Neal Clark
Дата:
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,
Neal

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>

 



Вложения