Slony-i在Postgre 9.3/slony 2.2.0/window 7上进行复制

Question

标题: slony-i复制不起作用。

二进制路径：C:\Program Files\PostgreSQL\9.3\share

Master.txt

cluster name = testing;

node 1 admin conninfo = 'dbname=original host=localhost user=postgres password=sa';
node 2 admin conninfo = 'dbname=copy host=localhost user=postgres password=sa';

init cluster (id = 1,comment = 'Node 1 - Master');
create set (id = 1, origin = 1);

set add table (set id = 1,origin = 1,id = 1 , full qualified name = 'public.test');
store node(id = 2,event node = 1,comment = 'slave');

store path(server = 1,client = 2,conninfo = 'dbname=original host=localhost user=postgres password=sa');
store path(server = 2,client = 1,conninfo = 'dbname=copy host=localhost user=postgres password=sa');

Slave.txt

CLUSTER NAME = testing;

node 1 admin conninfo = 'dbname=original host=localhost port=5432 user=postgres password=sa';
node 2 admin conninfo = 'dbname=copy host=localhost port=5432 user=postgres password=sa';

subscribe set (id = 1,provider = 1, receiver = 2, forward = no);

错误

​

​

问题

一直在等待事件，当我测试复制时，甚至出现slony复制也无法工作。

谢谢你

Answer 1

您需要在主计算机和从机器上创建一个slony服务。

创建一个文件并将其命名为slon.conf，内容如下：

cluster_name=testing

conn_info = 'dbname = original host = localhost user = postgres password = sa port = 5432'

然后，转到命令提示符，转到postgres bin文件夹并键入：

slon -regservice Slony-I

slon -addengine Slony-I slon.conf

slon -listengines Slony-I

这必须在主从机器上完成