PostgreSQL
How do I upgrade the PostgreSQL version in Applications Manager?
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 ...
PostgreSQL Monitor Addition Fails with “Invalid value for parameter 'TimeZone'”
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 ...
Applications Manager Database Migration Using SQL Dump
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: ...
What are the prerequisites required to monitor 'Top 10 Queries By CPU' in KingbaseDB monitor?
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 ...
How can I troubleshoot the issue when attempting to add a PostgreSQL Database server, but encountering a failure with an error message prompt?
While attempting to add a PostgreSQL database monitor, if you encounter any errors, please follow the steps below based on the specific error received: Host not valid. Kindly check the host name given or PostgreSQL production server is down or The ...
What are the prerequisites required to monitor 'Top 10 Queries By CPU' in PostgreSQL monitor?
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 ...
How to import certificates for monitoring Postgres Server with SSL authentication?
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 ...
How to check whether the replication is configured or not in PostgreSQL DB-Server?
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 ...