1. Stop Applications Manager Ensure Applications Manager is completely stopped before proceeding. Windows : <AppManager_home>\shutdownApplicationsManager.bat -force Linux : <AppManager_home>/shutdownApplicationsManager.sh -force 2. Check and prepare ...
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 ...
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 ...
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 ...