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<[email protected]> > Sender: [email protected] > Date: Wed, 14 Sep 2011 18:09:59 > To: CS DBA<[email protected]> > Cc:<[email protected]> > 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 >> [email protected] >> http://lists.slony.info/mailman/listinfo/slony1-general > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general -- --------------------------------------------- Kevin Kempter - Constent State A PostgreSQL Professional Services Company www.consistentstate.com --------------------------------------------- _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
