1、 ./configure编译时出现错误
configure: error: /usr/lib64/pgsql//plpgsql.so|sl|dll is not found in the pkglibdir.
Please specify the pkglibdir with --with-pgpkglibdir=
解决办法:
编译时加上–with-pgpkglibdir=指定路径
例如: ./configure --with-pgpkglibdir=/usr/local/slony/pgpkg
2、 初始化集群时或开启节点slon进程时出错
(1)./slonik_init_cluster | slonik
<stdin:6: PGRES_FATAL_ERROR SET datestyle TO ‘ISO’; SET session_replication_role TO local; - ERROR: permission denied to set parameter "session_replication_role"Unable to set session configuration parameters
<stdin:6: PGRES_FATAL_ERROR select 1 from “pg_catalog”.pg_namespace N where N.nspname = ‘_cluster01’; - ERROR: current transaction is aborted, commands ignored until end of transaction block
<stdin:6: Error: cannot determine if namespace “_cluster01” exists in node 1
(2)./slon_start 1
cannot get sl_local_node_id - ERROR: permission denied for sequence sl_local_node_id
原因分析和解决办法:
两个错误的原因一样,是由于当前节点所配置的用户缺少某个权限,具体缺少什么权限暂时不知道,
可在slon_tools.conf配置文件中将该节点用户修改为postgres即可解决,例如: