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