Re: streaming replication does not work across datacenter with 20ms latency? - Mailing list pgsql-general

From Tomas Vondra
Subject Re: streaming replication does not work across datacenter with 20ms latency?
Date
Msg-id 0fc5474eebcaed138c41670ea5c82df5.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: streaming replication does not work across datacenter with 20ms latency?  (Yan Chunlu <springrider@gmail.com>)
Responses Re: streaming replication does not work across datacenter with 20ms latency?  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: streaming replication does not work across datacenter with 20ms latency?  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: streaming replication does not work across datacenter with 20ms latency?  (Yan Chunlu <springrider@gmail.com>)
List pgsql-general
On 23 Červenec 2011, 18:14, Yan Chunlu wrote:
> thanks for the help!
> are there any other possible reasons?
>
> both system are using Debian amd64, as uname -a shows:
> Linux washington 2.6.26-2-amd64 #1 SMP Tue Mar 9 22:29:32 UTC 2010
> x86_64 GNU/Linux

It is not just about the architecture, it means the PostgreSQL was
configured somehow differently during the build. E.g. a different block
size or WAL block size would make such problems.

Or maybe one of the buils might be 32-bit for some reason (you can run
32-bit system in a 64-bit environment). You can do this

$ less postgres | grep Class

to check this (ELF32 => 32bit, ELF64 => 64bit).

Did you use the same binary packages or have you built the server yourself?

Tomas


pgsql-general by date:

Previous
From: Godofredo Contreras
Date:
Subject: Re: Question about uuid_generate_v3
Next
From: "Joshua D. Drake"
Date:
Subject: Re: streaming replication does not work across datacenter with 20ms latency?