logfile per DataBase

Поиск
Список
Период
Сортировка
Искать

logfile per DataBase

От:
Lutz Steinborn <l.steinborn@4c-ag.de>
Дата:
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

Re: logfile per DataBase

От:
"Igor Neyman" <ineyman@perceptron.com>
Дата:


> -----Original Message-----
> From: Lutz Steinborn [mailto:l.steinborn@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 

FAQ