Re: streaming replication does not work across datacenter with 20ms latency?

From: Yan Chunlu <springrider(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Tomas Vondra <tv(at)fuzzy(dot)cz>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: streaming replication does not work across datacenter with 20ms latency?
Date: 2011-07-25 14:26:15
Message-ID: CAOA66tEO_hoL-_1VNSC8_oSGGGiciYfK-1aZ9qcirLU98_wh6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

seems the Master server is compiled using 4.6.0:
version
----------------------------------------------------------------------------------------------------------------------------
PostgreSQL 9.0.4 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.6.real
(Debian 4.6.0-6) 4.6.1 20110428 (prerelease), 64-bit

and there is no way to know what slave is using since I have remove it.

I am using a compiled version(gcc 4.3.2) of postgresql as slave,
seems working now.

I think the problem maybe is like Fujii said, does that bug only
effect hot-stanby server? seems master is okay.

On Mon, Jul 25, 2011 at 10:06 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Tomas Vondra" <tv(at)fuzzy(dot)cz> writes:
>> On 25 Červenec 2011, 11:39, Yan Chunlu wrote:
>>> I am using debian ant apt-get to install postgresql, dpkg list shows
>>> they are the same?  is there anyway to tell what's version it is
>>> compiled from? thanks!
>
>> AFAIK there's no way to find out which compiler was used to build
>> PostgreSQL binaries (IIRC this is not in pg_config).
>
> No, but "SELECT version();" should tell the tale.
>
>                        regards, tom lane
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-07-25 14:47:47 Re: streaming replication does not work across datacenter with 20ms latency?
Previous Message Tom Lane 2011-07-25 14:06:16 Re: streaming replication does not work across datacenter with 20ms latency?