pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Breaking out log by database
3+ messages / 3 participants
[nested] [flat]

* Breaking out log by database
@ 2004-04-27 17:21  Chris Hoover <revoohc@sermonaudio.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Chris Hoover @ 2004-04-27 17:21 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Breaking out log by database
@ 2004-04-27 19:26  Bruno Wolff III <bruno@wolff.to>
  parent: Chris Hoover <revoohc@sermonaudio.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Bruno Wolff III @ 2004-04-27 19:26 UTC (permalink / raw)
  To: Chris Hoover <revoohc@sermonaudio.com>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Breaking out log by database
@ 2004-04-27 19:47  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: Bruno Wolff III <bruno@wolff.to>
  0 siblings, 0 replies; 3+ messages in thread

From: Bruce Momjian @ 2004-04-27 19:47 UTC (permalink / raw)
  To: Bruno Wolff III <bruno@wolff.to>; +Cc: Chris Hoover <revoohc@sermonaudio.com>; pgsql-admin

\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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-04-27 19:47 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-27 17:21 Breaking out log by database Chris Hoover <revoohc@sermonaudio.com>
2004-04-27 19:26 ` Bruno Wolff III <bruno@wolff.to>
2004-04-27 19:47   ` Bruce Momjian <pgman@candle.pha.pa.us>

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