Re: [ADMIN] Time Zone in Postgres

Hi Tom, We have different databases with different versions. I checked the database with *version 8.2.4* by running the below query echo select timestamp with time zone \'epoch\' + 1206970200 \* INTERVAL \'1 second\'\; | psql template1 ?column? --- 2008-03-31 23

Re: [ADMIN] Time Zone in Postgres

I copied the system zonefiles into the postgres database and it works fine now. This is anyway a temporary solution until we upgrade all our systems. Thanks to all for your suggestions and help. Tom Lane wrote: Shilpa Sudhakar <[EMAIL PROTECTED]> writes: As i said, we have version 8.2.4

Re: [ADMIN] Time Zone in Postgres

Shilpa Sudhakar <[EMAIL PROTECTED]> writes: > As i said, we have version 8.2.4 databases and if i need to just update > the timezone files for this database do i copy the zoneinfo files from > the OS zonefile or from the newer version of Postgres zonefiles. If your platform uses the standard zon

Re: [ADMIN] Time Zone in Postgres

Hi Tom, Thanks. I'll look into upgrading the database. Since we have a huge bunch of databases i was thinking of an alternative for now. As i said, we have version 8.2.4 databases and if i need to just update the timezone files for this database do i copy the zoneinfo files from the OS zonef

Re: [ADMIN] Time Zone in Postgres

Alvaro Herrera <[EMAIL PROTECTED]> writes: > Shilpa Sudhakar wrote: >> If DST changes are done in version 8.2.5 and up, is there any way to >> recompile the timezone files in our existing versions without upgrading. > FWIW this change is also in 8.1.11. ... and 8.0.14 ... Anyway, yes, you coul

Re: [ADMIN] Time Zone in Postgres

Shilpa Sudhakar wrote: > Hi Tom, > > If DST changes are done in version 8.2.5 and up, is there any way to > recompile the timezone files in our existing versions without upgrading. FWIW this change is also in 8.1.11. -- Alvaro Herrerahttp://www.CommandPrompt.com

Re: [ADMIN] Time Zone in Postgres

Hi Tom, I live in Adelaide Australia. I checked in 3 servers and all of them have "Australia/South" when i ran "show timezone" For the new timezone files, do i need to apply a timezone patch? Thanks Tom Lane wrote: Shilpa Sudhakar <[EMAIL PROTECTED]> writes: 1) Checked the *postgresql.c

Re: [ADMIN] Time Zone in Postgres

Shilpa Sudhakar wrote: > Hi Tom, > > If DST changes are done in version 8.2.5 and up, is there any way to > recompile the timezone files in our existing versions without upgrading. Why would you do that? It's silly. Just upgrade. -- Alvaro Herrerahttp://www.Co

Re: [ADMIN] Time Zone in Postgres

Shilpa Sudhakar <[EMAIL PROTECTED]> writes: > 1) Checked the *postgresql.conf file* and the *timezone *parameter is > set as "*unknown*". What does SHOW TIMEZONE report? Given the above, Postgres will try to deduce what zone your operating system is using, but that doesn't always work perfectly

Re: [ADMIN] Time Zone in Postgres

Hi Tom, If DST changes are done in version 8.2.5 and up, is there any way to recompile the timezone files in our existing versions without upgrading. Thanks Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: Shilpa Sudhakar wrote: From 2008, the DST ends on first Sunday of A

Re: [ADMIN] Time Zone in Postgres

Hi Alvaro, Thanks for the info. I assume Postgresql should have already known about the DST changes in Australia. I'll check the mailing list from the link you sent to see if there's anything regarding this. Thanks and Regards, Alvaro Herrera wrote: Shilpa Sudhakar wrote: From 2008

Re: [ADMIN] Time Zone in Postgres

Alvaro Herrera <[EMAIL PROTECTED]> writes: > Shilpa Sudhakar wrote: >> From 2008, the DST ends on first Sunday of April and not on the last Sun >> of March. > Please report this issue to the guys maintaining the TZ database > upstream: You sure they don't know about it already? # southeast Aust

Re: [ADMIN] Time Zone in Postgres

Shilpa Sudhakar wrote: > From 2008, the DST ends on first Sunday of April and not on the last Sun > of March. Please report this issue to the guys maintaining the TZ database upstream: http://news.gmane.org/gmane.comp.time.tz Because my country is having a TZ DST change this Saturday, a new re

Re: [ADMIN] Time Zone in Postgres

On Fri, Mar 07, 2008 at 09:26:51AM +1030, Shilpa Sudhakar wrote: > Hi Tom, > > We have different databases with different versions. > > I checked the database with *version 8.2.4* by running the below query > > echo select timestamp with time zone \'epoch\' + 1206970200 \* INTERVAL > \'1 second

Re: [ADMIN] Time Zone in Postgres

Hi Cat, As per my previous mail, i've done few checks on the postgres timezone files but not sure if am looking at the right file. I'll paste the details again below . 1) Checked the *postgresql.conf file* and the *timezone *parameter is set as "*unknown*". 2) */local/pkgsrc/databases/pos

Re: [ADMIN] Time Zone in Postgres

Hi Tom, We have different databases with different versions. I checked the database with *version 8.2.4* by running the below query echo select timestamp with time zone \'epoch\' + 1206970200 \* INTERVAL \'1 second\'\; | psql template1 ?column? --- 2008-03-31 2

Re: [ADMIN] Time Zone in Postgres

Vishal Arora <[EMAIL PROTECTED]> writes: > Hi, I've been working on a timezone issue. I am in Adelaide Australia > and the daylight savings time this year has been changed. I am trying > to figure out the file which is required to be changed. The easiest and best solution would be to update to a n

[ADMIN] Time Zone in Postgres

Hi, I've been working on a timezone issue. I am in Adelaide Australia and the daylight savings time this year has been changed. I am trying to figure out the file which is required to be changed. I've done the below research:1) Checked the postgresql.conf file and the timezone parameter i