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)
