From the objective of OSS-DB Exam Gold
- Troubleshooting - Troubleshooting common failures
Sample Question
4.03
When connecting to PostgreSQL as a superuser, the following message was output.
FATAL: sorry, too many clients already
Choose the one accurate reason for this error message.
-
The number of simultaneous connections exceeded the value set by the max_connections parameter.
-
The number of concurrent connections exceeded the value set by the superuser_reserved_connections parameter.
-
The number of concurrent connections exceeded the value set by the db_connections parameter.
-
The number of concurrent connections exceeded the value of (max_connections - superuser_reserved_connections).
-
The number of concurrent connections exceeded the value of (db_connections - superuser_reserved_connections).
※This sample exam is different from those that appear in the actual OSS-DB Exam.
2025/06/02
Answer and Explanation
This is the error message displayed when the number of concurrent connections to the server exceeds the limit.
A. This parameter specifies the maximum number of simultaneous connections to the server. The error message is generated when this limit is exceeded.
B. This parameter specifies the number of connections reserved for superusers. Exceeding the superuser_reserved_connections limit will not generate the error message in question.
C. The parameter db_connections does not exist.
D. (max_connections - superuser_reserved_connections) represents the maximum number of connections available to non-superusers. If a non-superuser attempts to connect beyond this value, the following error is generated: "FATAL: remaining connection slots are reserved for non-replication superuser connections".
E. The parameter db_connections does not exist.
Therefore, the correct answer is A.