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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
