Re: Feature request -- Log Database Name

On Mon, 28 Jul 2003, Tom Lane wrote:

> Date: Mon, 28 Jul 2003 21:39:23 -0400
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: Robert Treat <xzilla@users.sourceforge.net>
> Cc: ohp@pyrenet.fr, Larry Rosenman <ler@lerctr.org>,
>      Josh Berkus <josh@agliodbs.com>,
>      pgsql-hackers list <pgsql-hackers@postgresql.org>
> Subject: Re: [HACKERS] Feature request -- Log Database Name
>
> Robert Treat <xzilla@users.sourceforge.net> writes:
> > I think better would be a GUC "log_to_table" which wrote all standard
> > out/err to a pg_log table.  of course, I doubt you could make this
> > foolproof (how to log startup errors in this table?) but it could be a
> > start.
>
> How would a failed transaction make any entries in such a table?  How
> would you handle maintenance operations on the table that require
> exclusive lock?  (vacuum full, reindex, etc)
>
> It seems possible that you could make this work if you piped stderr to a
> buffering process that was itself a database client, and issued INSERTs
> to put the rows into the table, and could buffer pending data whenever
> someone else had the table locked (eg for vacuum).  I'd not care to try
> to get backends to do it locally.
>
>             regards, tom lane
Not quite, my goal is to have a log per database, the stderr dosn't
contain enough information to split it.

As an ISP, I would like that each customer having one or more databases
being able to see any error on their database.
I imagine have a log file per database would be toot complicated...
>

-- 
Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
FRANCE                          Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)