I can't say for sure if this will solve your problem, but try rebuilding/ r=
einstalling slony with the following options

First
locate pg_config
locate libpq.so

Then reconfigure with =

./configure --with-pgconfigdir=3D/usr/postgres/8.3 --with-pglibdir=3D/usr/p=
ostgres/8.3/lib

IOW =

--with-pgconfigdir=3D Location of the PostgreSQL pg_config program.
--with-pglibdir=3D=A0=A0=A0=A0=A0 Location of the PostgreSQL libs. (second =
locate)

make
make install

Melvin Davidson =

 =



--- On Thu, 5/28/09, Rainer Duffner <rainer at ultra-secure.de> wrote:

From: Rainer Duffner <rainer at ultra-secure.de>
Subject: [Slony1-general] Problem running slonik on Solaris: slony1_funcs n=
ot found
To: slony1-general at lists.slony.info
Date: Thursday, May 28, 2009, 7:21 PM

Hi,

I have compiled slony1-2.0.2 on Solaris x86 10U6 with the SUN-supplied Post=
greSQL 8.3.

When I want to run it, I get:
-bash-3.00# slonik < initcluster
<stdin>:6: PGRES_FATAL_ERROR load '$libdir/slony1_funcs';=A0 - ERROR:=A0 co=
uld not access file "$libdir/slony1_funcs": No such file or directory
<stdin>:6: Error: the extension for the Slony-I C functions cannot be loade=
d in database 'host=3Dlocalhost dbname=3Dpgbench user=3Dpostgres port=3D543=
2'
-bash-3.00#


Is it possible to see where it's actually looking for that file?
It is available:
-bash-3.00# ls -l /usr/postgres/8.3/lib/slony1_funcs.so
-rwxr-xr-x=A0=A0=A01 root=A0 =A0=A0=A0root=A0 =A0 =A0=A0=A051376 Mai 28 03:=
06 /usr/postgres/8.3/lib/slony1_funcs.so
-bash-3.00#


How do I debug that best?

I have installed:
-bash-3.00# pkginfo |grep postg
system=A0 =A0 =A0 SUNWpostgr-82-libs=A0 =A0 =A0 =A0 =A0 =A0=A0=A0PostgreSQL=
 8.2 client libraries
system=A0 =A0 =A0 SUNWpostgr-83-client=A0 =A0 =A0 =A0 =A0=A0=A0PostgreSQL c=
lient tools
system=A0 =A0 =A0 SUNWpostgr-83-contrib=A0 =A0 =A0 =A0 =A0 PostgreSQL commu=
nity contributed tools not part of core product
system=A0 =A0 =A0 SUNWpostgr-83-devel=A0 =A0 =A0 =A0 =A0 =A0 PostgreSQL dev=
elopment tools and header files
system=A0 =A0 =A0 SUNWpostgr-83-libs=A0 =A0 =A0 =A0 =A0 =A0=A0=A0PostgreSQL=
 client libraries
system=A0 =A0 =A0 SUNWpostgr-83-pl=A0 =A0 =A0 =A0 =A0 =A0 =A0=A0=A0PostgreS=
QL additional Perl, Python & TCL server procedural languages
system=A0 =A0 =A0 SUNWpostgr-83-server=A0 =A0 =A0 =A0 =A0=A0=A0PostgreSQL d=
atabase server
system=A0 =A0 =A0 SUNWpostgr-83-server-data-root PostgreSQL database server=
 data directories and root components
system=A0 =A0 =A0 SUNWpostgr-83S=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=A0=A0Postgr=
eSQL (Source)
system=A0 =A0 =A0 SUNWpostgr-jdbc=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 JDBC drive=
rs for PostgreSQL
-bash-3.00#



Regards,
Rainer
_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general



      =

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090528/=
400f85a9/attachment.htm