Am 29.11.2011 23:49, schrieb Tom Lane:
Another way that we've sometimes recommended people handle custom login restrictions is (1) use PAM for authentication (2) find or write a PAM plugin that makes the kind of check you want
Very interesting - I'll first try the connlimit approach hinted at by Filip, but if PostgreSQL does normal session setup/teardown using PAM (I've never used PAM authentication for PostgreSQL before), this should be a workable solution in case using iptables doesn't turn out to properly handle disconnected sessions quickly enough.
Thanks for pointing me at the PAM! -- --- Heiko. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
