Logging not working

Started by Phoenix Kiulaover 14 years ago3 messagesgeneral
Jump to latest
#1Phoenix Kiula
phoenix.kiula@gmail.com

Hi. PG 9.0.5, on CentOS 5 with 64 bit.

Here's the logging related items from my config file:

log_directory = 'pg_log'
log_filename = 'pglog.postgresql-%Y-%m-%d_%H%M%S.log'
log_rotation_age = 1d
log_min_duration_statement = 5000 # In milliseconds

That's it.

The directory "/var/lib/pgsql/data/pg_log" is chowned by
postgres:postgres. And it's even chmodded 777, just to be sure that
anyone can write to it. (For now)

Why's there no log then? What can I do?

Thanks!

#2Tomas Vondra
tomas.vondra@2ndquadrant.com
In reply to: Phoenix Kiula (#1)
Re: Logging not working

On 19 Listopad 2011, 20:29, Phoenix Kiula wrote:

Hi. PG 9.0.5, on CentOS 5 with 64 bit.

Here's the logging related items from my config file:

log_directory = 'pg_log'
log_filename = 'pglog.postgresql-%Y-%m-%d_%H%M%S.log'
log_rotation_age = 1d
log_min_duration_statement = 5000 # In milliseconds

That's it.

The directory "/var/lib/pgsql/data/pg_log" is chowned by
postgres:postgres. And it's even chmodded 777, just to be sure that
anyone can write to it. (For now)

Why's there no log then? What can I do?

What about log_destination and log_collector?

Tomas

#3Phoenix Kiula
phoenix.kiula@gmail.com
In reply to: Tomas Vondra (#2)
Re: Logging not working

On Sun, Nov 20, 2011 at 3:38 AM, Tomas Vondra <tv@fuzzy.cz> wrote:

What about log_destination and log_collector?

Thanks. This was it!

Much appreciated.