Thread: Error to install Slony I on Postgresql
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 " I can fix this error on SUSE Linux Enterprise Server 10 (i586). But when i apply the same way to fix it on SUSE Linux Enterprise Server 10 (x86_64), i'm not successful Can you help me ?? Please !!! -- View this message in context: http://old.nabble.com/Error-to-install-Slony-I-on-Postgresql-tp26687956p26687956.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Mon, Dec 7, 2009 at 7:56 PM, maiphan2008 <maiphan2008@gmail.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?
Scott Marlowe-2 wrote: > > On Mon, Dec 7, 2009 at 7:56 PM, maiphan2008 <maiphan2008@gmail.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@postgresql.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?? Thank you. -- View this message in context: http://old.nabble.com/Error-to-install-Slony-I-on-Postgresql-tp26687956p26688657.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Mon, Dec 7, 2009 at 9:42 PM, maiphan2008 <maiphan2008@gmail.com> wrote: > > > > Scott Marlowe-2 wrote: >> >> On Mon, Dec 7, 2009 at 7:56 PM, maiphan2008 <maiphan2008@gmail.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@postgresql.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.
P.s. I build slony I v 1.2.x all the time on 64 bit Centos with no problems at all.