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
---------------------------------------------
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
