PPAS上运行pg_dump经过II

这一次，我用三台机器。

其他步骤和<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$