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@sss.pgh.pa.us> wrote:
> "Tomas Vondra" <tv@fuzzy.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
>