Re: [GENERAL] Regarding timezone

2014-09-17 Thread Adrian Klaver
On 09/17/2014 01:14 PM, Dev Kumkar wrote: On Thu, Sep 18, 2014 at 1:22 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 09/17/2014 12:26 PM, Dev Kumkar wrote: I hope the binaries archive containing ""pgsql/share/postgresql/ timezone/Europe/Moscow" uploaded at

Re: [GENERAL] Regarding timezone

2014-09-17 Thread Dev Kumkar
On Thu, Sep 18, 2014 at 1:22 AM, Adrian Klaver wrote: > On 09/17/2014 12:26 PM, Dev Kumkar wrote: > >> I hope the binaries archive containing ""pgsql/share/postgresql/ >> timezone/Europe/Moscow" uploaded at >> http://www.enterprisedb.com/products-services-training/pgbindownload >> will also get c

Re: [GENERAL] Regarding timezone

2014-09-17 Thread Adrian Klaver
On 09/17/2014 12:26 PM, Dev Kumkar wrote: On Thu, Sep 18, 2014 at 12:01 AM, Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: The next set of minor releases, whenever those are (and no, there's no schedule). I hope the binaries archive containing ""pgsql/share/postgresql/ timezone/Europe/Mos

Re: [GENERAL] Regarding timezone

2014-09-17 Thread Dev Kumkar
On Thu, Sep 18, 2014 at 12:01 AM, Tom Lane wrote: > The next set of minor releases, whenever those are (and no, there's > no schedule). > I hope the binaries archive containing ""pgsql/share/postgresql/ timezone/Europe/Moscow" uploaded at http://www.enterprisedb.com/products-services-training/pg

Re: [GENERAL] Regarding timezone

2014-09-17 Thread Tom Lane
Dev Kumkar writes: > Which upgraded postgres version will have the corrected Moscow timezone? The next set of minor releases, whenever those are (and no, there's no schedule). > Tom, can you too provide your comments on the mentioned hack here. It would break timezone reporting for historical M

Re: [GENERAL] Regarding timezone

2014-09-17 Thread Dev Kumkar
On Wed, Sep 17, 2014 at 8:52 PM, Adrian Klaver wrote: > > I am not that versed in the timezone handling to make a definitive > statement. I would say it should work until you upgrade. At that point the > new Moscow timezone should be correct and the change will not matter. I > would verify on the

Re: [GENERAL] Regarding timezone

2014-09-17 Thread Adrian Klaver
On 09/17/2014 07:53 AM, Dev Kumkar wrote: On Wed, Sep 17, 2014 at 7:24 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: 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

Re: [GENERAL] Regarding timezone

2014-09-17 Thread Dev Kumkar
On Wed, Sep 17, 2014 at 7:24 PM, Adrian Klaver wrote: > 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/shar

Re: [GENERAL] Regarding timezone

2014-09-17 Thread Adrian Klaver
On 09/16/2014 11:43 PM, Dev Kumkar wrote: On Tue, Sep 16, 2014 at 6:16 PM, Dev Kumkar mailto:devdas.kum...@gmail.com>> wrote: On Fri, Sep 12, 2014 at 7:31 PM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: What OS and what packaging? For both windows-64-bit and Li

Re: [GENERAL] Regarding timezone

2014-09-16 Thread Dev Kumkar
On Tue, Sep 16, 2014 at 6:16 PM, Dev Kumkar wrote: > On Fri, Sep 12, 2014 at 7:31 PM, Adrian Klaver > wrote: > >> >> What OS and what packaging? >> >> For both windows-64-bit and Linux-64-bit. > PostgreSQL version - 9.3.4 > > I believe the file "pgsql/share/postgresql/timezone/Europe/Moscow" wil

Re: [GENERAL] Regarding timezone

2014-09-16 Thread Dev Kumkar
On Fri, Sep 12, 2014 at 7:31 PM, Adrian Klaver wrote: > > What OS and what packaging? > > For both windows-64-bit and Linux-64-bit. PostgreSQL version - 9.3.4 I believe the file "pgsql/share/postgresql/timezone/Europe/Moscow" will require changes. As the above changes will then be reflected in t

Re: [GENERAL] Regarding timezone

2014-09-12 Thread Adrian Klaver
On 09/11/2014 10:59 PM, Dev Kumkar wrote: On Wed, Sep 10, 2014 at 8:43 PM, Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: You'd want to get a new version of the IANA timezone database files for that. Depending on what packaging you're using, this might be an operating-system update no

Re: [GENERAL] Regarding timezone

2014-09-11 Thread Dev Kumkar
On Wed, Sep 10, 2014 at 8:43 PM, Tom Lane wrote: > You'd want to get a new version of the IANA timezone database files for > that. Depending on what packaging you're using, this might be an > operating-system update not a Postgres update. If you are relying > on the Postgres copies, you'd have

Re: [GENERAL] Regarding timezone

2014-09-10 Thread Tom Lane
Dev Kumkar writes: > I want to change the timezone to Europe/Moscow. Moscow timezone is changing > from +4 to +3 You'd want to get a new version of the IANA timezone database files for that. Depending on what packaging you're using, this might be an operating-system update not a Postgres update.

[GENERAL] Regarding timezone

2014-09-10 Thread Dev Kumkar
Hello, I want to change the timezone to Europe/Moscow. Moscow timezone is changing from +4 to +3 On the box, I have changed the timezone to MSK+3. >From the db side I have modified the following files: 1)postgresql.conf timezone = 'Europe/Moscow' 2)pgsql/share/postgresql/time