pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedlogfile per DataBase
2+ messages / 2 participants
[nested] [flat]
* logfile per DataBase
@ 2012-02-24 13:54 Lutz Steinborn <l.steinborn@4c-ag.de>
0 siblings, 1 reply; 2+ messages in thread
From: Lutz Steinborn @ 2012-02-24 13:54 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: logfile per DataBase
@ 2012-02-24 20:51 Igor Neyman <ineyman@perceptron.com>
parent: Lutz Steinborn <l.steinborn@4c-ag.de>
0 siblings, 0 replies; 2+ messages in thread
From: Igor Neyman @ 2012-02-24 20:51 UTC (permalink / raw)
To: Lutz Steinborn <l.steinborn@4c-ag.de>; pgsql-admin
> -----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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-02-24 20:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-02-24 13:54 logfile per DataBase Lutz Steinborn <l.steinborn@4c-ag.de>
2012-02-24 20:51 ` Igor Neyman <ineyman@perceptron.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox