Admin nice-to-have's

From: Scott Shattuck <ss(at)technicalpursuit(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Admin nice-to-have's
Date: 2002-08-15 19:53:56
Message-ID: 1029441237.12097.6271.camel@idearat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

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

ss

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message cbbrowne 2002-08-15 20:01:04 Re: Standard replication interface?
Previous Message Tom Lane 2002-08-15 19:51:46 Re: Open 7.3 items