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: dbbf25900901291316y3613e930wed1c687c3f1e0010@mail.gmail.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group