Windows PostgreSQL Update Timezone Data Turkey government has announced that Turkey will stay on GMT+3.

We've waited for OS pathces to update tzdata on PostgreSQL.
Now, timezone patch for Windows is installed.

On Linux, restarting PostgreSQL service is enough.
But on Windows, restarting did not help.

postgres=#select extract(timezone from '2017-01-01'::timestamptz);
date_part
---------
7200


On linux;

postgres=#select extract(timezone from '2017-01-01'::timestamptz);
date_part
---------
10800


I need to update timezone datas for PostgreSQL on Windows.

Can anyone help me to solve this?

Also I am sure that timezone change patch is installed.

PostgreSQL versions are 9.2 and 9.5
Today PostgreSQL released new minor versions.
In these versions timezone datas updated to 2016h.

Released versions;


9.6.1
9.5.5
9.4.10
9.3.15
9.2.19


Also you don't have to upgrade your installation.

You can move new timezone datas to your installation and restart the service.
It's all done.
It's worth the wait.