Re: Error to install Slony I on Postgresql

On Mon, Dec 7, 2009 at 9:42 PM, maiphan2008 <maiphan2008(at)gmail(dot)com> wrote:
>
>
>
> Scott Marlowe-2 wrote:
>>
>> On Mon, Dec 7, 2009 at 7:56 PM, maiphan2008 <maiphan2008(at)gmail(dot)com> wrote:
>>>
>>> Dear All,
>>>
>>> I have a server :SUSE Linux Enterprise Server 10 (x86_64)
>>> postgresql-8.31.i586 is installed on this server.
>>>
>>> When I install slony1-2.0.2, I have a error "Your version of libpq
>>> doesn't
>>> have PQunescapeBytea      which means that your version of PostgreSQL is
>>> lower than 7.3      and thus not even remotely supported by Slony-I
>>> version
>>> 2 "
>>
>> 1: Slony 1 V2 isn't really ready for prime time yet.  I installed it a
>> few months ago in production on 8.3.8 and it promptly started causing
>> phantom locks to appear that hung the whole db and replication engine
>> requiring db restarts.  We had more downtime in a week than we'd had
>> in the previous year.
>>
>> 2: Are you sure you're using the latest libpq in that instance and
>> that you don't have an old one installed somehow somewhere?
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>>
>
> Thanks Scott Marlowe-2.
> 1. I will consider more.
> 2. I read config.log file. And I see:
> /usr/lib64/gcc/x86_64-suse-linux/4.1.2/../../../../x86_64-suse-linux/bin/ld:
> skipping incompatible /usr/lib/libpq.so when searching for -lpq
> /usr/lib64/gcc/x86_64-suse-linux/4.1.2/../../../../x86_64-suse-linux/bin/ld:
> skipping incompatible /usr/lib/libpq.a when searching for -lpq
> /usr/lib64/gcc/x86_64-suse-linux/4.1.2/../../../../x86_64-suse-linux/bin/ld:
> cannot find -lpq
>
> It is conflicted between 32bit and 64 bit. Do you know to compile them??

You might need some libpq devel packages to be installed... Other
than that I'm lost.