| From: | "Tomas Vondra" <tv(at)fuzzy(dot)cz> |
|---|---|
| To: | "Yan Chunlu" <springrider(at)gmail(dot)com> |
| Cc: | "Scott Ribe" <scott_ribe(at)elevated-dev(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: streaming replication does not work across datacenter with 20ms latency? |
| Date: | 2011-07-23 17:55:08 |
| Message-ID: | 0fc5474eebcaed138c41670ea5c82df5.squirrel@sq.gransy.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2011-07-23 18:25:19 | Re: streaming replication does not work across datacenter with 20ms latency? |
| Previous Message | Godofredo Contreras | 2011-07-23 17:17:08 | Re: Question about uuid_generate_v3 |