What Inappropriate Parameter Settings Cause Unavailability of the RDS for PostgreSQL Database?
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
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.
Database Parameter Modification FAQs
- What Inappropriate Parameter Settings Cause Unavailability of the RDS for PostgreSQL Database?
- How Can I Change the Time Zone?
- How Do I Configure a Password Expiration Policy for RDS for MySQL DB Instances?
- How Do I Change the RDS Transaction Isolation Level?
- How Do I Ensure that the Character Set of an RDS MySQL Database Is Correct?
- Does RDS for PostgreSQL Support the test_decoding Plugin?
- How Do I Use the utf8mb4 Character Set to Store Emojis in an RDS for MySQL DB Instance?
- Where Should I Store NDF Files for RDS for SQL Server?
- Can I Use SQL Commands to Modify Global Parameters?
- How Do I Modify the Collation of RDS for SQL Server?
- How Do I Set Case Sensitivity for RDS for MySQL Table Names?
- Can I Enable Query Caching for My RDS for MySQL Instance?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore