Re: Admin nice-to-have's - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Admin nice-to-have's
Date
Msg-id 200209020115.g821F9m08030@candle.pha.pa.us
Whole thread Raw
In response to Admin nice-to-have's  (Scott Shattuck <ss@technicalpursuit.com>)
List pgsql-hackers
Scott Shattuck wrote:
> A couple of admin nice-to-have's based on the last few weeks of 24x7
> operation are:
> 
> Allow DBA/Database Owner to log in even when max_connections has been
> reached so they can determine which queries are hung via
> pg_stat_activity etc. and perform any other needed work to restore
> stability.

Done for 7.3.

> Log offending query during DEBUG logging for syntax errors, missing
> tables/attributes, etc. so that the offending queries can be located in
> the codebase.

Probably in 7.3.

--  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,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: "Giuseppe R. Papavero"
Date:
Subject: Possible ODBC Driver Bug (via VC++/MFC CRecordset)
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: [COMMITTERS] pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...