pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBreaking 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