The following bug has been logged on the website:
Bug reference: 7858
Logged by: Jackie Zhang
Email address: jackie.qq.zhang@gmail.com
PostgreSQL version: 9.1.4
Operating system: Ubuntu
Description: =
Hi,
The log message of the sanity check for "superuser_reserved_connections" in
PostmasterMain() is not accurate. See the following code snippet:
/*src/backend/postmaster/postmaster.c*/
730 /*
731 * Check for invalid combinations of GUC settings.
732 */
733 if (ReservedBackends >=3D MaxBackends)
734 {
735 write_stderr("%s: superuser_reserved_connections must
be less than max_connections\n", progname);
736 ExitPostmaster(1);
737 }
The problem is that "MaxBackends" is calculated by both
"autovacuum_max_workers" and "max_connections". See assign_maxconnections()
and assign_autovacuum_max_workers() in src/backend/utils/misc/guc.c.
The log message should inform both the two configuration parameters instead
of only one -- the root cause could be the oversized
"autovacuum_max_workers".
Thanks,
Jackie