Wed Sep 14 11:56:11 PDT 2011
- Previous message: [Slony1-general] PostgreSQL 9.1 support?
- Next message: [Slony1-general] Errors adding a 3rd slave with SLONY 2.0.7
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] PostgreSQL 9.1 support?
- Next message: [Slony1-general] Errors adding a 3rd slave with SLONY 2.0.7
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list