CS DBA cs_dba at consistentstate.com
Wed Sep 14 11:56:11 PDT 2011
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

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
---------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20110914/ac2e271b/attachment-0001.htm 


More information about the Slony1-general mailing list