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