Re: Admin nice-to-have's

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Scott Shattuck <ss(at)technicalpursuit(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Admin nice-to-have's
Date: 2002-09-02 01:15:09
Message-ID: 200209020115.g821F9m08030@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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 Christopher Kings-Lynne 2002-09-02 01:38:27 Re: [COMMITTERS] pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...
Previous Message Giuseppe R. Papavero 2002-09-02 00:36:40 Possible ODBC Driver Bug (via VC++/MFC CRecordset)