[ADMIN] logfile per DataBase

2012-02-24 Thread 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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


Re: [ADMIN] logfile per DataBase

2012-02-24 Thread Igor Neyman


 -Original Message-
 From: Lutz Steinborn [mailto:l.steinb...@4c-ag.de]
 Sent: Friday, February 24, 2012 8:55 AM
 To: pgsql-admin@postgresql.org
 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.
 
 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

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 


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin