Add new GUC reserved_connections.
Robert Haas <rhaas@postgresql.org>
Add new GUC reserved_connections. This provides a way to reserve connection slots for non-superusers. The slots reserved via the new GUC are available only to users who have the new predefined role pg_use_reserved_connections. superuser_reserved_connections remains as a final reserve in case reserved_connections has been exhausted. Patch by Nathan Bossart. Reviewed by Tushar Ahuja and by me. Discussion: http://postgr.es/m/20230119194601.GA4105788@nathanxps13
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +37 −2 |
| doc/src/sgml/user-manag.sgml | modified | +5 −0 |
| src/backend/postmaster/postmaster.c | modified | +20 −9 |
| src/backend/storage/lmgr/proc.c | modified | +11 −5 |
| src/backend/utils/init/postinit.c | modified | +23 −8 |
| src/backend/utils/misc/guc_tables.c | modified | +11 −0 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +1 −0 |
| src/include/catalog/pg_authid.dat | modified | +5 −0 |
| src/include/postmaster/postmaster.h | modified | +1 −0 |
| src/include/storage/proc.h | modified | +1 −1 |
Documentation touched
Discussion
- almost-super-user problems that we haven't fixed yet 66 messages · 2023-01-16 → 2023-03-17