尝试运行文档中的示例 slony 配置脚本,但出现以下错误:
postgres$ /tmp/slonik_example.sh
<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=my_primary host=localhost user=warfish password=coalitions'
然而 LIBDIR 变量设置正确:
postgres$ ./pg_config
BINDIR = /opt/local/lib/postgresql90/bin
DOCDIR = /opt/local/share/doc/postgresql
HTMLDIR = /opt/local/share/doc/postgresql
INCLUDEDIR = /opt/local/include/postgresql90
PKGINCLUDEDIR = /opt/local/include/postgresql90
INCLUDEDIR-SERVER = /opt/local/include/postgresql90/server
LIBDIR = /opt/local/lib/postgresql90
并且该库存在:
ls -l /opt/local/lib/postgresql90/slony1_funcs.so
-rwxr-xr-x 1 root admin 34944 Feb 17 16:20 /opt/local/lib/postgresql90/slony1_funcs.so
脚本如下:
cat /tmp/slonik_example.sh
#!/bin/sh
CLUSTERNAME=slony_example;
/opt/local/lib/postgresql90/bin/slonik <<_EOF_
define CLUSTERNAME slony_example;
cluster name = @CLUSTERNAME;
node 1 admin conninfo = 'dbname=my_primary host=localhost user=user1 password=pw';
node 2 admin conninfo = 'dbname=my_rep host=localhost user=user1 password=pw';
#--
# init the first node. Its id MUST be 1. This creates the schema # _$CLUSTERNAME containing all replication system specific database # objects.
#--
init cluster ( id=1, comment='Master Node');
#--
# Slony-I organizes tables into sets. The smallest unit a node can # subscribe is a set. The following commands create one set containing # all 4 pgbench tables. The master or origin of the set is node 1.
#--
create set (id=1, origin=1, comment='All pgbench tables');
set add table (set id=1, origin=1, id=1, fully qualified name='public.pgbench_accounts', comment='accounts table');
set add table (set id=1, origin=1, id=2, fully qualified name='public.pgbench_branches', comment='branches table');
set add table (set id=1, origin=1, id=3, fully qualified name='public.pgbench_tellers', comment='tellers table');
set add table (set id=1, origin=1, id=4, fully qualified name='public.pgbench_history', comment='history table');
#--
# Create the second node (the slave) tell the 2 nodes how to connect to Slony-I 2.1.1 Documentation 10 / 163
# each other and how they should listen for events.
#--
store node (id=2, comment = 'Slave node', event node=1);
store path (server = 1, client = 2, conninfo='dbname=my_primary host=localhost user=user1 password=pw');
store path (server = 2, client = 1, conninfo='dbname=my_rep host=localhost user=user1 password=pw');
_EOF_
在文档中阅读可能 lib 不在正确的位置或 $libdir 设置不正确,但一切看起来都已到位。我是否错过了其他我不知道的东西?
在我的情况下,这个错误是由于 Slony 没有安装在集群中的每台机器上造成的。我在主主机/主机上安装了 Slony 和所有必需的库,但客户端也需要安装 Slony(或者可能只是放入的库函数文件
$libdir
)。在我的数据库 slony1_funcs.so 中,它位于 PKGLIBDIR 目录中
PKGLIBDIR = /usr/lib64/pgsql
我找到了有关“PKGLIBDIR vs LIBDIR”的信息:
" libdir 用于构建时可链接库,任何您可能希望作为 -lxxx 传递的内容。所以典型的位置是 /usr/lib、/usr/local/lib 或 /usr/local/pgsql/lib。pkglibdir 用于动态可加载库“