Re: [GENERAL] 8.4 vs. 9.x: 127.0.0.0/8

2015-08-12 Thread Felipe Gasper
Dear Martín, Thank you for leading us to the right solution! (We’re also suspecting some change in the networking stack from CentOS 6 to 7 may be playing a part here, too, FYI.) -FG On 11 Aug 2015 6:30 PM, Martín Marqués wrote: I think there might be some misunderstanding here: El

Re: [GENERAL] Sync replication + high latency server

2015-08-12 Thread Joshua D. Drake
On 08/12/2015 05:33 PM, Edson Richter wrote: Hi! I've a situation where I would like to keep sync replication, where servers have 10Mbps network connection but high latency (normally, ~20ms but sometimes, 1000ms~2000ms, even 3000ms when network is under load). Considering that I will keep enou

[GENERAL] Sync replication + high latency server

2015-08-12 Thread Edson Richter
Hi! I've a situation where I would like to keep sync replication, where servers have 10Mbps network connection but high latency (normally, ~20ms but sometimes, 1000ms~2000ms, even 3000ms when network is under load). Considering that I will keep enough WAL files (let's say, 200 WAL segments on a

Re: [GENERAL] Chars problem restoring to ps 8.4 (utf8) a dumped db from ps 8.1 (latin9)

2015-08-12 Thread Tom Lane
Adrian Klaver writes: > On 08/12/2015 06:46 AM, Bianchi Quota Leonardo wrote: >> I "SOLVED" it doing this way but don't know what I did and I don't know >> which consequences would have in future, then I need to know if it's ok... >> >> Starting on BOX1 >> $pg_dump --no-privileges --no-owner -h

Re: [GENERAL] Chars problem restoring to ps 8.4 (utf8) a dumped db from ps 8.1 (latin9)

2015-08-12 Thread Adrian Klaver
On 08/12/2015 06:46 AM, Bianchi Quota Leonardo wrote: Hi, I'm trying to move a db from postgres 8.1 encoded LATIN9 from a debian 4.0 box to postgres 8.4 encoded UTF8 on a rh6.6 (the whole job is to dismiss the old server, migrate and upgrade bugzilla application) FYI, 8.4 is no longer communi

[GENERAL] Chars problem restoring to ps 8.4 (utf8) a dumped db from ps 8.1 (latin9)

2015-08-12 Thread Bianchi Quota Leonardo
Hi, I'm trying to move a db from postgres 8.1 encoded LATIN9 from a debian 4.0 box to postgres 8.4 encoded UTF8 on a rh6.6 (the whole job is to dismiss the old server, migrate and upgrade bugzilla application) I would like to restore dumped data in the new utf8 db solving the problem of chars li