Admin nice-to-have's
Scott Shattuck <ss@technicalpursuit.com>
From: Scott Shattuck <ss@technicalpursuit.com>
To: pgsql-hackers@postgresql.org
Date: 2002-08-15T19:53:56Z
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