Skip site navigation (1) Skip section navigation (2)

Re: logfile per DataBase

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 (view raw or flat)
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 


In response to

pgsql-admin by date

Next:From: Brian WeaverDate: 2012-02-24 22:30:58
Subject: Problems with pg_restore (plpgsql already exists)
Previous:From: Lutz SteinbornDate: 2012-02-24 13:54:57
Subject: logfile per DataBase

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group