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: dbbf25900901291316y3613e930wed1c687c3f1e0010@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi.
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

postgresql.log.1233263415
postgresql.log.1233263531

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?

Responses

Browse pgsql-novice by date

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