On Mon, Jan 17, 2011 at 8:58 AM, Magnus Hagander <mag...@hagander.net> wrote: >>>> What do you have in mind? >>> >>> Either having it controlled by log_connections, or perhaps have a >>> log_highpriv_connections that controls replication *and* superuser, to >>> be somewhat consistent. >> >> -1. We could provide an option to turn this on and off, but I >> wouldn't want it merged with log_connections or logging of superuser >> connections. > > Fair enough, we could have a log_replication_connections as a separate > one then? Or having one log_connections, one > log_replication_connections and one log_superuser_connections?
log_replication_connections seems reasonable. Not sure about log_superuser_connections. >> Incidentally, I think ClientAuthentication_hook is sufficiently >> powerful to allow logging of superuser connections but no others, if >> someone wanted to write a contrib module. That doesn't necessarily >> mean an in-core facility wouldn't be useful too, but it's at least >> worth thinking about using the hook. > > Do we have an example of this hook somewhere already? If not, it could > be made into a useful example of that, perhaps? contrib/auth_delay -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers