Dear List,
I already asked my question on the admin list, but got no answer. As I even could not find any related information anywhere, I think my question is a wish:
Would it be possible to set the maximum number of connections to each database individually? I need this because the server will be shared between several users and I want to avoid that that somebody uses the maximum number of connections possible to the server, locking out others.
I am not familiar with the internals of postgresql, but maybe a column in pg_database could store the limit if any.
A similar solution would be if the number of connections could be limited per users, a similar column in pg_user could store the limit.
Or this limit could be configured as an additional column in pg_hba.conf.
How hard would it be to implement such a feature? As there is a check on each new connection to the server, maybe it would not be too difficult to check one constraint more :-)
I don't have much time to do it, but if you think it is not too hard and my limited knowledge in C is enough I would help doing it gladly.
These feature would be good even as a "hidden" feature, configurable only through psql after startup (file configuration support added later).
thanks,
attila
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
