1.1.1. Parameter Issues
What inappropriate parameter settings cause the unavailability of the RDS-PostgreSQL database instance?
Inappropriate settings of some RDS-PostgreSQL database parameters may cause the unavailability of the database, which are listed below Please operate with caution.
• You need to refer to the instance specifications when setting some parameters. Too large or too small parameters may cause the unavailability of the database. For instance. the values of the parameters shared_buffers and max_connections are related to the physical memory size of the instance, which cannot be set at will. The parameters have been tuned when RDS-PostgreSQL is enabled. We recommend that you use RDS-PostgreSQL based on the default configuration to ensure that the database is available.
• Some parameters are associated with each other, and inappropriate settings may also cause the database to be unavailable: For example, the configuration of the parameters max_connections, autovacuum_max_workers, and max_worker_processes must meet the following requirements. Otherwise, the database is unavailable: max_connections parameter value + autovacuum_max_workers parameter value + max_worker_processes parameter value + 1<8388607
Description
For detailed parameter settings, see instructions on the PostgreSQL official website.
1.1.2. Version Issues
How do I view the kernel version number of an RDS-PostgreSQL instance?
• You can go to the List of Instances page of the Tenant Console and check the database version attributes, where you can see the instance kernel version number. For instance, the database version for the RDS-PostgreSQL instance in the List of Instances is 12.16_P6, and the corresponding community version is 12.16.
² Note
You can also connect to an instance and execute the statement show server_version to check the database version.
Does RDS-PostgreSQL support kernel upgrades across major versions?
RDS-PostgreSQL does not support kernel grades across major versions. To use a high-level engine version, you can create a high-version instance and use eSurfing Cloud DTS products to migrate the data of a low-version instance to a higher version instance to complete the upgrade. For details, see PostgreSQL Data Migration.