On Wed, Sep 17, 2014 at 7:24 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
Regards..
So you will need to determine what method you binaries use. If they are using the system timezone data, you will need to update that.
Thanks!
Just a hack here, how about copying "pgsql/share/postgresql/timezone/Etc/GMT-3" as "pgsql/share/postgresql/timezone/Europe/Moscow"
This will make the pg_timezone_names() function to return output as follows:
>> "Europe/Moscow";"GMT-3";"03:00:00";f
>> "Europe/Moscow";"GMT-3";"03:00:00";f
With this "now()" function returns expected data for Moscow timezone.
Please let me know your comments here.
Regards..