On 11/7/18 5:19 PM, Tom Lane wrote: > > ... > > I think this proposal boils down to asking for support for an > incredibly bad application design, and equipping every database with > an additional foot-gun in order to have that. >
I'm not sure about that. IMHO being able to restrict the number of superuser connections can be used to force users to use regular (non-superuser) roles for stuff that does not require that. Which should encourage better application design. Of course, the question is whether such limit can actually be enforced reliably (I mean, can't the superuser simply change it?) and whether handing over superuser accounts to application users is a good idea in general ... regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
