What Inappropriate Parameter Settings Will Cause Unavailability of My RDS for PostgreSQL Instance?
In the following cases, inappropriate parameter settings cause the database to be unavailable:
- Parameter value ranges are related to DB instance specifications.
The maximum values of shared_buffers and max_connections are related to the DB instance physical memory. If you set these parameters inappropriately, the database will be unavailable.
- Parameter association is incorrect.
max_connections, autovacuum_max_workers, and max_worker_processes must meet the following requirements. Otherwise, the database is unavailable.
max_connections value + autovacuum_max_workers value + max_worker_processes value + 1 < 8388607
Note
For additional details, visit the PostgreSQL official website.
Solution:
- Log in to the RDS console and query the logs to locate the incorrectly configured parameters.
- On the Configuration page, change parameters to default values and reboot the database.
- Configure the incorrect parameter values and restore other parameters to their original default values.
Parent topic: Database Parameter Modification