BUG #7528: Spurious empty log file created

From: ajeru(at)topolyte(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7528: Spurious empty log file created
Date: 2012-09-10 15:05:24
Message-ID: E1TB5YC-00080h-Qv@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7528
Logged by: Alexander Jerusalem
Email address: ajeru(at)topolyte(dot)com
PostgreSQL version: 9.2.0
Operating system: Linux (Ubuntu x86_64, kernel version 2.6.18)
Description:

I have the following log configuration in postgresql.conf:

log_destination = 'csvlog'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'pg-%Y-%m-%d_%H%M%S.log'
log_rotation_age = 1d
log_rotation_size = 10MB

After removing all files from pg_log and relaunching the postgres server,
pg_log contains two files instead of one: pg-xxx.log and pg-xxx.csv.
According to the documentation, only pg-xxx.csv should exist. And in fact
only pg-xxx.csv is actually written to whilst pg-xxx.log remains empty.

Using a .csv extenson or no extension at all for the log_filename setting
doesn't help either. Postgres always creates a file named exactly as the
log_filename setting says and a second one with .csv appended.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-09-10 16:09:33 Re: BUG #7528: Spurious empty log file created
Previous Message Kevin Grittner 2012-09-10 12:19:45 Re: BUG #7524: Partitioning