Timezone information

From: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Timezone information
Date: 2014-02-19 14:19:19
Message-ID: CALSLE1N0EtGip+YQRu=eSexN6wxWm_BX1nd29FTc9fGPuXKfEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How to set timezone in postgreSQL database to pick operating system level
timezone information.

In postgresql.conf there exists "timezone" parameter whose value can be set.
However this value needs to be in format 'US/Pacific', 'Asia/Calcutta' and
so on to work correctly.

Is there any database query to get operating system level timezone
information and then set accordingly.

Took a look into pg_timezone_names table and

SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }

When postgres is installed on IST timezone windows operating system,
registry key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation
has TimeZoneKeyName set as "India Standard Time". However post installation
postgresql.conf has timezone information set as 'Asia/Calcutta', is there
any binary which can be executed?

Regards...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2014-02-19 14:38:00 Re: why VARIADIC functions executed on array input?
Previous Message Tjibbe 2014-02-19 14:17:44 why VARIADIC functions executed on array input?