BUG #7528: Spurious empty log file created - Mailing list pgsql-bugs

From ajeru@topolyte.com
Subject BUG #7528: Spurious empty log file created
Date
Msg-id E1TB5YC-00080h-Qv@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7528: Spurious empty log file created  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7528
Logged by:          Alexander Jerusalem
Email address:      ajeru@topolyte.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 =3D 'csvlog'
logging_collector =3D on
log_directory =3D 'pg_log'
log_filename =3D 'pg-%Y-%m-%d_%H%M%S.log'
log_rotation_age =3D 1d
log_rotation_size =3D 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.

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: BUG #7524: Partitioning
Next
From: Tom Lane
Date:
Subject: Re: BUG #7528: Spurious empty log file created