On 09/14/2011 05:11 PM, Jan Wieck wrote:
> 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.

aah, I think this may be the issue. I din one install of slony against 
the 9.1.0 instance (./configure 
--with-pgconfigdir=/usr/local/pgsql-910/bin) and used it for all 3 
instances.


Thanks I'll give it a shot and report back


> 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


-- 
---------------------------------------------
Kevin Kempter       -       Constent State
A PostgreSQL Professional Services Company
           www.consistentstate.com
---------------------------------------------