Re: Feature request -- Log Database Name

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Feature request -- Log Database Name
Date: 2003-07-30 19:35:10
Message-ID: 200307301935.h6UJZAb00642@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus wrote:
> Guys:
>
> > That assumes we know what the shape of the log tables will be, but this
> > isn't quite clear to me - I can imagine it being different for different
> > needs. Having an external program to parse the logs into INSERT
> > statements would not be hard, anyway, so I'm not sure that this would
> > buy us much. I'll think about it more. In any case, it should be done in
>
> My simple suggestion would be to have the option of outputting log entries as
> tab-delimited data. Then the admin could very easily write a script to load
> it into a table or tables; we could even supply a sample perl script on
> techdocs or somewhere.

The problem with that is needing to output to multiple tables ---
session-level, query-level, and server-level tables.

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-07-30 19:39:53 Re: Upgrading my BSDI box, again
Previous Message Bruce Momjian 2003-07-30 19:22:30 Re: Feature request -- Log Database Name