2007 Daylight Savings Time
From PostgreSQL Forums Wiki
The table below shows the versions that include the patches required for the 2007 daylight savings time changes. Depending on your region you may require different versions of the database. It is recommended that you upgrade your database to the latest patch version that would not require you to dump & restore the database.
| Current Version | United States | Canada | Western Australia |
| < 8.0 | Patch your operating system. | ||
| 8.0 | 8.0.4 | 8.0.10 | 8.0.10 |
| 8.1 | No patch is necessary. | 8.1.6 | 8.1.6 |
| 8.2 | No patch is necessary. | ||
If you are unable to upgrade, then you should read the Recompile time zone data article to learn how to upgrade your timezone database if you are using 8.0 or later.
You can verify whether your database already has a patch or an updated timezone database by using the following query (which is for the United States, but easily adapted to other time zones):
SET TIMEZONE = 'EST5EDT'; SELECT CASE WHEN timestamptz '20070401 0100' + interval '1 hour' >= '20070401 0300' THEN 'Wrong' ELSE 'Right' END;
