Re: [GENERAL] Unexpected array_remove results

2015-03-20 Thread Tom Lane
Matija Lesar writes: > should not in example below array_remove return same results? AFAICS, array_remove keeps the existing lower bound number. I don't see anything particularly wrong with that definition. Even if we didn't care about backwards compatibility, it would require nontrivial effort

Re: [GENERAL] [pgadmin-support] Issue with a hanging apply process on the replica db after vacuum works on primary

2015-03-20 Thread Vladimir Borodin
> 19 марта 2015 г., в 20:30, Sergey Shchukin > написал(а): > > 17.03.2015 13:22, Sergey Shchukin пишет: >> 05.03.2015 11:25, Jim Nasby пишет: >>> On 2/27/15 5:11 AM, Sergey Shchukin wrote: show max_standby_streaming_delay; max_standby_streaming_delay --

[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.

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

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 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 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] Sequences not created, bug in pg_dump?

2015-03-20 Thread Leonardo M. Ramé
El 19/03/15 a las 14:13, Adrian Klaver escibió: On 03/19/2015 10:02 AM, "Leonardo M. Ramé" wrote: El 19/03/15 a las 13:09, Adrian Klaver escibió: On 03/19/2015 08:43 AM, "Leonardo M. Ramé" wrote: Hi, I'm creating a database dump excluding one table and found only the sequences created impl

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 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] Sequences not created, bug in pg_dump?

2015-03-20 Thread Adrian Klaver
On 03/20/2015 10:21 AM, "Leonardo M. Ramé" wrote: El 19/03/15 a las 14:13, Adrian Klaver escibió: On 03/19/2015 10:02 AM, "Leonardo M. Ramé" wrote: El 19/03/15 a las 13:09, Adrian Klaver escibió: On 03/19/2015 08:43 AM, "Leonardo M. Ramé" wrote: Hi, I'm creating a database dump excluding