这一次,我用三台机器。
其他步骤和<PPAS上运行pg_dump经过>中讲到的一样。
http://www.cnblogs.com/gaojian/p/3195321.html
只是,pg_dump 命令是在第三台机器上执行:
[root@cmdsv ~]# ifconfig eth0 Link encap:Ethernet HWaddr 08:00:27:38:B7:DE inet addr:192.168.10.200 Bcast:192.168.10.255 Mask:255.255.255.0 inet6 addr: fe80::a00:27ff:fe38:b7de/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:621 errors:0 dropped:0 overruns:0 frame:0 TX packets:236 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:701827 (685.3 KiB) TX bytes:31552 (30.8 KiB) Base address:0xd010 Memory:f0000000-f0020000
[root@cmdsv ~]# su - enterprisedb -bash-3.2$ cd bin -bash-3.2$ pwd -bash-3.2$ ./pg_dump -h 192.168.10.88 -s masterdb | ./psql -h 192.168.10.99 slavedb SET SET SET SET SET CREATE EXTENSION COMMENT CREATE EXTENSION COMMENT CREATE EXTENSION COMMENT SET SET SET CREATE TABLE ALTER TABLE CREATE TABLE ALTER TABLE REVOKE REVOKE GRANT GRANT -bash-3.2$