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

From Scott Shattuck
Subject Admin nice-to-have's
Date
Msg-id 1029441237.12097.6271.camel@idearat
Whole thread Raw
Responses Re: Admin nice-to-have's  (Neil Conway <nconway@klamath.dyndns.org>)
Re: Admin nice-to-have's  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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






pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Open 7.3 items
Next
From: cbbrowne@cbbrowne.com
Date:
Subject: Re: Standard replication interface?