Re: [GENERAL] Timezone mismatch

2015-03-20 Thread Vick Khera
On Fri, Mar 20, 2015 at 1:55 PM, "Leonardo M. Ramé" wrote: > Well, pg_load_conf didn't reoload the timezone config from > postgresql.conf, I had to restart the service to be changed. > That's par for the course for pretty much any long-living process. The time zone is initialized once and only o

Re: [GENERAL] Timezone mismatch

2015-03-20 Thread Leonardo M. Ramé
El 20/03/15 a las 14:11, "Leonardo M. Ramé" escibió: El 20/03/15 a las 13:03, Adrian Klaver escibió: I am not sure what the exact issue is? How are you determining that the new time zone is not being used? What was the old time zone, what is the new one? I don't know if the new time zone is be

Re: [GENERAL] Timezone mismatch

2015-03-20 Thread Leonardo M. Ramé
El 20/03/15 a las 13:03, Adrian Klaver escibió: I am not sure what the exact issue is? How are you determining that the new time zone is not being used? What was the old time zone, what is the new one? I don't know if the new time zone is beign used, It just coincede with the old local time zo

Re: [GENERAL] Timezone mismatch

2015-03-20 Thread Adrian Klaver
On 03/20/2015 08:43 AM, "Leonardo M. Ramé" wrote: El 20/03/15 a las 12:38, Steve Crawford escibió: On 03/20/2015 08:29 AM, "Leonardo M. Ramé" wrote: Hi, I had to change the O.S. timezone and aparently PostgreSql continues using the old timezone, how can I force update it's time zone?. Using Po

Re: [GENERAL] Timezone mismatch

2015-03-20 Thread Leonardo M. Ramé
El 20/03/15 a las 12:38, Steve Crawford escibió: On 03/20/2015 08:29 AM, "Leonardo M. Ramé" wrote: Hi, I had to change the O.S. timezone and aparently PostgreSql continues using the old timezone, how can I force update it's time zone?. Using PostgreSql 8.4 on Ubuntu Server 12.04. To update t

Re: [GENERAL] Timezone mismatch

2015-03-20 Thread Steve Crawford
On 03/20/2015 08:29 AM, "Leonardo M. Ramé" wrote: Hi, I had to change the O.S. timezone and aparently PostgreSql continues using the old timezone, how can I force update it's time zone?. Using PostgreSql 8.4 on Ubuntu Server 12.04. To update the OS timezone I used sudo dpkg-reconfigure tzdata

[GENERAL] Timezone mismatch

2015-03-20 Thread Leonardo M. Ramé
Hi, I had to change the O.S. timezone and aparently PostgreSql continues using the old timezone, how can I force update it's time zone?. Using PostgreSql 8.4 on Ubuntu Server 12.04. To update the OS timezone I used sudo dpkg-reconfigure tzdata Regards, -- Leonardo M. Ramé http://leonardorame.