Use the following table to identify the PostgreSQL minor version applicable to your Applications Manager build. PostgreSQL version to upgrade to Applications Manager build 15.17 180400 15.18 181100, 180403 and above in the 1804xx hotfix series 17.11 ...
Error Message: 'FATAL: invalid value for parameter "TimeZone": "Asia/Calcutta" Cause This error occurs when the PostgreSQL server returns a timezone value that the AppManager JVM does not recognize. Troubleshooting Run the following query on the ...
Step 1: Rename Directories Skip this step if the directories are already renamed. Rename <AppManager_home>/working/pgsql to <AppManager_home>/working/pgsql_11. Rename <AppManager_home>/working/pgsql_15.5 to <AppManager_home>/working/pgsql. Step 1.1: ...
1. Include the below lines in kingbase.conf file located in <Data DIRECTORY>: shared_preload_libraries = 'sys_stat_statements' sys_stat_statements.track = all 2. Execute the below commands in psql shell if the extension sys_stat_statements is not ...
Applications Manager reports a specific message for each reason a PostgreSQL connection fails. Find the message you see below and follow that section. The same messages apply to KingbaseES monitors, with the differences noted in the last section. 1. ...
1. Include the below lines in postgrsql.conf file located in <Data DIRECTORY>: shared_preload_libraries = 'pg_stat_statements' pg_stat_statements.track = all 2. Execute the below commands in psql shell: CREATE EXTENSION pg_stat_statements; 3. Restart ...
Before adding a PostgreSQL server that requires SSL authentication, you must import the server's SSL certificates into the Applications Manager trust store (cacerts) to establish a secure connection. Attempting to add without import might give ...
For Version 10 or above: On master node: Run the following command in psql shell: select client_addr, state, sent_lsn, write_lsn, flush_lsn, replay_lsn from pg_stat_replication; Output: If it displays "empty-set" --> replication is not ...