Help Center/ Relational Database Service_RDS for PostgreSQL/ FAQs/ Database Parameter Modification/ How Do I Change the Time Zone of My RDS for PostgreSQL Instance?
Updated on 2025-06-24 GMT+08:00

How Do I Change the Time Zone of My RDS for PostgreSQL Instance?

RDS for PostgreSQL allows you to select a time zone when you create an instance and change the time zone after the instance is created.

After the time zone parameter is modified, you need to reconnect to the instance for the modification to take effect.

  1. Log in to the management console.
  2. Click in the upper left corner and select a region.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the target DB instance.
  5. In the navigation pane on the left, choose Parameters.
  6. Search for the time zone parameter timezone in the search box.
  7. Select a time zone, and click Save.
  8. In the displayed dialog box, click OK.

    For example, to change the time zone to UTC+08:00, select Asia/Shanghai from the drop-down list.

Time Zone Parameters

  • system_time_zone: operating system (OS) time zone. This parameter cannot be changed and it has no impact on the database time zone.
  • timezone: database time zone. You can modify this parameter to change the time zone for your DB instance.