If you have 2 (or more) PG installations on a system, it is important to build Slony using --with-pgconfigdir for each one, Slony is going to be used with.

Jan
--
Sent from a mobile device

-----Original Message-----
From: Steve Singer <ssinger_pg at sympatico.ca>
Sender: slony1-general-bounces at lists.slony.info
Date: Wed, 14 Sep 2011 18:09:59 
To: CS DBA<cs_dba at consistentstate.com>
Cc: <slony1-general at lists.slony.info>
Subject: Re: [Slony1-general] Errors adding a 3rd slave with SLONY 2.0.7

CS DBA wrote:
>   Hi All;
> 
> I'm getting this error:
> 
> 
> <stdin>:8: PGRES_FATAL_ERROR load '$libdir/slony1_funcs';  - ERROR:  
> could not access file "$libdir/slony1_funcs": No such file or 
> directory                                                           
> <stdin>:8: Error: the extension for the Slony-I C functions cannot be 
> loaded in database 'dbname=node3_5434 host=localhost port=5434 user=slony'
> 
> 
> Here's what I did:
> 
> 1) installed both postgres versions 9.0.4 and 9.1.0 in different 
> directories on the same Linux server
> 

You didn't include the steps of when you compiled and installed slony. 
Since it can't find the shared functions file (slony_funcs.so) in your 
postgresql libe directory maybe you missed this.

2. ./configure --with-pgconfigdir=/usr/local/pgsql90/bin
make clean
make install
3. ./configure --with-pgconfigdir=/usr/local/pgsql91/bin
make clean
make install



> 2) initialized and started (2) 9.1.0 clusters on ports 5432 and 5433
> 
> 3) initialized and started one (1) 9.0.4 cluster on port 5434
> 
> 4) did a full slony setup on the 2 9.1.0 instances (master on port 5432 
> and slave on port 5433) with no issues
> 
> 5) setup the DDL on slave #2, the 9.0.4 instance and try to execute the 
> script including the below code block, gives me the error (variables are 
> set correctly):
> 
> 
> slonik <<_EOF_
> 
> cluster name = $CLUSTERNAME;
> 
> 
> node 1 admin conninfo = 'dbname=$NODE1_DBNAME host=$NODE1_HOST 
> port=$NODE1_PORT user=$REPUSER';
> node 3 admin conninfo = 'dbname=$NODE3_DBNAME host=$NODE3_HOST 
> port=$NODE3_PORT user=$REPUSER';
> 
> store node (id=3, comment = 'NODE 3', event node = 1);
> 
> store path (server = 1, client = 3, conninfo='dbname=$NODE1_DBNAME 
> host=$NODE1_HOST port=$NODE1_PORT user=$REPUSER');
> store path (server = 3, client = 1, conninfo='dbname=$NODE3_DBNAME 
> host=$NODE3_HOST port=$NODE3_PORT user=$REPUSER');
> 
> _EOF_
> 
> 
> Thoughts?
> 
> 
> Thanks in advance...
> 
> -- 
> ---------------------------------------------
> Kevin Kempter       -       Constent State 
> A PostgreSQL Professional Services Company
>           www.consistentstate.com
> ---------------------------------------------
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general

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