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

How to log to postgresql.log

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to log to postgresql.log
Date: 2009-01-29 21:16:12
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
I'd like to log everything to PGDATA/pg_log/postgresql.log  with
rotation when it reaches the size of 1kB (yes, that is not much, but
I'll increase when I see it work)
I have
these lines uncommented in the postgresql.conf file.

logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql.log'
log_truncate_on_rotation = off
log_rotation_size = 1kB

But I get  files


so it starts new logs each time I start the server.
Why? I don't want the extra part in the file name. How do I get rid of them?


pgsql-novice by date

Next:From: Bob McConnellDate: 2009-01-29 22:26:00
Subject: Re: REALLY stupid question
Previous:From: Carol WalterDate: 2009-01-29 18:57:28
Subject: Re: Remove duplicate rows and order by number of occurences

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