[ADMIN] logfile per DataBase

[Lutz Steinborn]

Hello,

is it possible to configure postgresql to produce one logfile per database
in a cluster?
I can't find any hint about this in the doc.

Something like:
log_filename = 'postgresql-[DBNAME]-%Y-%m-%d_%H%M%S.log'

It would be very use full for a development server.

have a happy weekend

Lutz

[Igor Neyman]

-----Original Message-----
Sent: Friday, February 24, 2012 8:55 AM
Subject: logfile per DataBase
Hello,
is it possible to configure postgresql to produce one logfile per
database in a cluster?
I can't find any hint about this in the doc.
log_filename = 'postgresql-[DBNAME]-%Y-%m-%d_%H%M%S.log'
It would be very use full for a development server.
have a happy weekend
Lutz

No, it is not possible.

But, inside log file you can use %d for "log_line_prefix" to specify
which db emitted particular line.

Regards,
Igor Neyman