BUG #3660: unused empty file is created with csvlog

Started by Thomas Reissover 18 years ago2 messagesbugs
Jump to latest
#1Thomas Reiss
thomas.reiss@interieur.gouv.fr

The following bug has been logged online:

Bug reference: 3660
Logged by: Thomas Reiss
Email address: thomas.reiss@interieur.gouv.fr
PostgreSQL version: 8.3 beta 1
Operating system: Linux
Description: unused empty file is created with csvlog
Details:

Hello,

I just tried the csvlog logging method.
I set the following :
log_destination = 'csvlog'
logging_collector = on
log_filename = 'postgresql-%u'

At server start, PostgreSQL creates a file called "postgresql-2" (for today)
and a file "postgresql-2.csv".
File "postgresql-2" is empty and never used again, whereas
"postgresql-2.csv" contains the logs.

If log_filename is set to 'postgresql-%u.csv', PostgreSQL creates two files
too: postgresql-2.csv and postgresql-2.csv.csv and uses the second one.

Regards,
Thomas

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Thomas Reiss (#1)
Re: BUG #3660: unused empty file is created with csvlog

"Thomas Reiss" <thomas.reiss@interieur.gouv.fr> writes:

I set the following :
log_destination = 'csvlog'
logging_collector = on
log_filename = 'postgresql-%u'

At server start, PostgreSQL creates a file called "postgresql-2" (for today)
and a file "postgresql-2.csv".

This is not a bug.

File "postgresql-2" is empty and never used again, whereas
"postgresql-2.csv" contains the logs.

The fact that you didn't observe anything being put into it doesn't
mean that will never happen.

regards, tom lane