| From: | "Igor Neyman" <ineyman(at)perceptron(dot)com> |
|---|---|
| To: | "Lutz Steinborn" <l(dot)steinborn(at)4c-ag(dot)de>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: logfile per DataBase |
| Date: | 2012-02-24 20:51:51 |
| Message-ID: | F4C27E77F7A33E4CA98C19A9DC6722A208D18740@EXCHANGE.corp.perceptron.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> -----Original Message-----
> From: Lutz Steinborn [mailto:l(dot)steinborn(at)4c-ag(dot)de]
> Sent: Friday, February 24, 2012 8:55 AM
> To: pgsql-admin(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Weaver | 2012-02-24 22:30:58 | Problems with pg_restore (plpgsql already exists) |
| Previous Message | Lutz Steinborn | 2012-02-24 13:54:57 | logfile per DataBase |