Thread: Breaking out log by database

Question,

I have several db servers that have postgresql clusters with many db's (5 upto
170) in them.  Is there a way to breakout the postgres logs by the database?

Thanks,

chris

On Tue, Apr 27, 2004 at 13:21:34 -0400,
  Chris Hoover <revoohc@sermonaudio.com> wrote:
> Question,
>
> I have several db servers that have postgresql clusters with many db's (5 upto
> 170) in them.  Is there a way to breakout the postgres logs by the database?

I don't think it is possible to do that in the released versions, but I know
there was some discussions about adding the database name to the log records
not too long ago. (Within the last couple of months.) So it may not be too
hard to do this in 7.5 when it is released.

\Bruno Wolff III wrote:
> On Tue, Apr 27, 2004 at 13:21:34 -0400,
>   Chris Hoover <revoohc@sermonaudio.com> wrote:
> > Question,
> >
> > I have several db servers that have postgresql clusters with many db's (5 upto
> > 170) in them.  Is there a way to breakout the postgres logs by the database?
>
> I don't think it is possible to do that in the released versions, but I know
> there was some discussions about adding the database name to the log records
> not too long ago. (Within the last couple of months.) So it may not be too
> hard to do this in 7.5 when it is released.

In 7.5, you have log_line_prefix, which can contain the database name as
a prefix on each log line.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073