This topic describes how to change the time zone of an ApsaraDB RDS for PostgreSQL instance.

Prerequisites

The RDS instance uses standard or enhanced SSDs.

Change the time zone

You can change the time zone only of an RDS instance that uses standard or enhanced SSDs. To change the time zone, log on to the ApsaraDB for RDS console and modify the timezone parameter on the Parameters page. For more information, see Reconfigure parameters for an RDS PostgreSQL instance.

timezone
Note If an RDS instance uses local SSDs, the timezone parameter is not supported.

Query supported time zones

You can run the following command to query supported time zones:

select name,utc_offset from pg_timezone_names;
Note For more information about the pg_timezone_names table, see pg_timezone_names.
Query supported time zones