<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi All;<br>
<br>
I'm getting this error:<br>
<br>
<br>
<stdin>:8: PGRES_FATAL_ERROR load '$libdir/slony1_funcs'; -
ERROR: could not access file "$libdir/slony1_funcs": No such file
or
directory
<br>
<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'<br>
<br>
<br>
Here's what I did:<br>
<br>
1) installed both postgres versions 9.0.4 and 9.1.0 in different
directories on the same Linux server<br>
<br>
2) initialized and started (2) 9.1.0 clusters on ports 5432 and 5433<br>
<br>
3) initialized and started one (1) 9.0.4 cluster on port 5434<br>
<br>
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<br>
<br>
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):<br>
<br>
<small><small><br>
slonik <<_EOF_ <br>
<br>
cluster name = $CLUSTERNAME;<br>
<br>
<br>
node 1 admin conninfo = 'dbname=$NODE1_DBNAME host=$NODE1_HOST
port=$NODE1_PORT user=$REPUSER';<br>
node 3 admin conninfo = 'dbname=$NODE3_DBNAME host=$NODE3_HOST
port=$NODE3_PORT user=$REPUSER';<br>
<br>
store node (id=3, comment = 'NODE 3', event node = 1);<br>
<br>
store path (server = 1, client = 3,
conninfo='dbname=$NODE1_DBNAME host=$NODE1_HOST port=$NODE1_PORT
user=$REPUSER'); <br>
store path (server = 3, client = 1,
conninfo='dbname=$NODE3_DBNAME host=$NODE3_HOST port=$NODE3_PORT
user=$REPUSER'); <br>
<br>
_EOF_</small></small><br>
<br>
<br>
Thoughts?<br>
<br>
<br>
Thanks in advance...<br>
<pre class="moz-signature" cols="72">--
---------------------------------------------
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
<a class="moz-txt-link-abbreviated" href="http://www.consistentstate.com">www.consistentstate.com</a>
---------------------------------------------</pre>
</body>
</html>