Re: logfile per DataBase - Mailing list pgsql-admin

From Igor Neyman
Subject Re: logfile per DataBase
Date
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A208D18740@EXCHANGE.corp.perceptron.com
Whole thread Raw
In response to logfile per DataBase  (Lutz Steinborn <l.steinborn@4c-ag.de>)
List 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


pgsql-admin by date:

Previous
From: Lutz Steinborn
Date:
Subject: logfile per DataBase
Next
From: Brian Weaver
Date:
Subject: Problems with pg_restore (plpgsql already exists)