PostgreSQL Monitor Addition Fails with “Invalid value for parameter 'TimeZone'”

PostgreSQL Monitor Addition Fails with “Invalid value for parameter 'TimeZone'”

Alert
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 PostgreSQL server you are trying to add as a monitor:
Quote
SHOW TimeZone;
Resolution
Case 1:
If the result of the SHOW TimeZone query is Asia/Calcutta, update it to Asia/Kolkata, then try adding the PostgreSQL monitor again.
Case 2:
Set the correct timezone for the AppManager service:
  1. Open <AppManager_Home>/working/conf/wrapper.conf
  2. Add (or update) the following entry:
    Quote
    wrapper.java.additional.33=-Duser.timezone=Asia/Kolkata
  3. Save the file and restart Applications Manager.
Verification
After restarting the service, try re-adding the PostgreSQL monitor. The connection should now succeed without the 'TimeZone' parameter error.
Notes
Ensure that:
  1. The server OS timezone,
  2. The PostgreSQL configuration (postgresql.conf → timezone), and
  3. The JVM timezone (in wrapper.conf)
are consistent and use valid timezone identifiers.