The following bug has been logged online:
Bug reference: 5466
Logged by: Dmitry Funk
Email address: diffor@gmail.com
PostgreSQL version: 8.4.4
Operating system: Windows 2003 R2
Description: Asia/Novosibirsk timezone problem
Details:
Current system timezone: Asia/Novosibisk
PostgreSQL on query "show timezone" show answer "Asia/Almaty"
Asia/Novosibisk has daylight saving time
Asia/Almaty NOT has daylight saving time
and result of now() is wrong
Workaround: "timezone = 'Asia/Novosibirsk'" in postgresql.conf
Affected only Windows, not Linux.
Sorry for my english...