On 09/22/2014 10:34 AM, Diego Puertas wrote:
> Hello All,
>
> As part of a migration process from Postgres 8.1 to 9.3 I'm trying to compile Slony 1.2.23 for Postgres 9.3.4 on an Ubuntu 14.04 box.
>
> The development package has been installed:
> 	postgresql-server-dev-9.3
>
> The configure command runs OK:
> 	./configure --with-pgsharedir='/usr/share/postgresql
>
> But when I run make, it breaks and complaints it can't find a library called pstrdup. This is the output of the make command:
>
> gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../.. -DPGSHARE="\"/usr/share/postgresql\"" -DPG_VERSION_MAJOR=9 slonik.o dbutil.o parser.o  ../parsestatements/scanner.o -L/usr/lib/ -L/usr/lib/postgresql/9.3/lib/ -lpq  -Wl,-rpath,/usr/lib/ -lpgport  -o slonik
> /usr/lib//libpgport.a(wait_error.o): In function `wait_result_to_str':
> (.text+0x110): undefined reference to `pstrdup'
>
>
> It looks like this problem is referred to on a bug report from May 2013, and it's due to the fact that Postgres 9.3 introduced a new library, libpgcommon. I've tried to link this library by adding the following line at the end of config/acx_libpq.m4 :
> 	LIBS="$LIBS -lpgcommon"
>
> But the result is the same.
>
> Did you find this problem before? How did you solve it?
>


Make sure that  the link line is like

gcc -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../.. 
-DPGSHARE="\"/usr/local/pgsql93/bin//../share/\"" -DPG_VERSION_MAJOR=9 
slonik.o dbutil.o parser.o  ../parsestatements/scanner.o 
-L/usr/local/pgsql93/lib/ -L/usr/local/pgsql93/lib/ -lpq 
-Wl,-rpath,/usr/local/pgsql93/lib/ -lpgport -lpgcommon -o slonik

so pgcommon comes after -lpgport.
You probably need to change src/slonik/Makefile  not config/acx_libpq.m4

That will fix the problem your having linking slonik, but the trigger 
from 1.2 will still fail to compile against 9.3.   You will either need 
to look at updating the 1.2 trigger to work against newer PG (and that 
might not be the only issue getting 1.2 to work against 9.3).

Or you could do your upgrade in stages, upgrade with slony 1.2 to 8.3 or 
8.4 or 9.0 then upgrade from that to PG 9.3 with a more modern slony.



>
> Thanks
>
> --
> Diego A Puertas
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>