利用管道迁移数据，管道迁移数据

利用管道迁移数据，管道迁移数据

磁盘空间不足的情况下，利用命名或者匿名管道迁移和导入数据；需要注意命名管道的权限问题。

0. Name PIP 0
[pg@h1 ~]$ psql gtlions -ac "select 't3' tab,count(*) from t3 union all select 't4',count(*) from t4;"
select 't3' tab,count(*) from t3 union all select 't4',count(*) from t4;
 tab | count
-----+-------
 t3  |   100
 t4  |     0
(2 rows)
 
[pg@h1 ~]$ mknod syncpip p
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to '/home/pg/sync'"|psql gtlions -p 5432 -c "copy t4 from '/home/pg/sync'"  
ERROR:  could not open file "/home/pg/sync" for reading: No such file or directory
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to '/home/pg/syncpip'"|psql gtlions -p 5432 -c "copy t4 from '/home/pg/syncpip'"  
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to '/home/pg/syncpip'"|psql gtlions -p 5432 -c "copy t4 from '/home/pg/syncpip'"        
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to '/home/pg/syncpip'"|psql gtlions -p 5432 -c "copy t4 from '/home/pg/syncpip'"  
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to '/home/pg/syncpip'"|psql gtlions -p 5432 -c "copy t4 from '/home/pg/syncpip'"  
COPY 100
[pg@h1 ~]$ psql gtlions -ac "select 't3' tab,count(*) from t3 union all select 't4',count(*) from t4;"
select 't3' tab,count(*) from t3 union all select 't4',count(*) from t4;
 tab | count
-----+-------
 t3  |   100
 t4  |   400
(2 rows)
1. Name PIP 1
[pg@h1 ~]$ rm -rf sync*
[pg@h1 ~]$ mkfifo syncpip
[pg@h1 ~]$ ll syncpip
prw-rw-r-- 1 pg pg 0 11月  6 09:15 syncpip
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to '/home/pg/syncpip'"|psql gtlions -p 5432 -c "copy t4 from '/home/pg/syncpip'"  
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to '/home/pg/syncpip'"|psql gtlions -p 5432 -c "copy t4 from '/home/pg/syncpip'"  
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to '/home/pg/syncpip'"|psql gtlions -p 5432 -c "copy t4 from '/home/pg/syncpip'"  
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to '/home/pg/syncpip'"|psql gtlions -p 5432 -c "copy t4 from '/home/pg/syncpip'"  
COPY 100
[pg@h1 ~]$ psql gtlions -ac "select 't3' tab,count(*) from t3 union all select 't4',count(*) from t4;"
select 't3' tab,count(*) from t3 union all select 't4',count(*) from t4;
 tab | count
-----+-------
 t3  |   100
 t4  |   800
(2 rows)
 
2. UnName PIP
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to stdout"|psql gtlions -p 5432 -c "copy t4 from stdin"                                      
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to stdout"|psql gtlions -p 5432 -c "copy t4 from stdin"  
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to stdout"|psql gtlions -p 5432 -c "copy t4 from stdin"  
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to stdout"|psql gtlions -p 5432 -c "copy t4 from stdin"  
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to '/home/pg/syncpip'"|psql gtlions -p 5432 -c "copy t4 from '/home/pg/syncpip'"  
COPY 100
[pg@h1 ~]$ psql gtlions -ac "select 't3' tab,count(*) from t3 union all select 't4',count(*) from t4;"                        
select 't3' tab,count(*) from t3 union all select 't4',count(*) from t4;
 tab | count
-----+-------
 t3  |   100
 t4  |  1300
(2 rows)

-EOF-

申请书
XXX供水公司
位于XXXX的的XX号建筑已由城建部门规划，并取得了《规划许可证》，但你单位的供水管道位于其中，因此，特申请你单位将供水管道迁移，费用由我支付。
特此申请
申请人：XXX
年月日
 

这点你完全不用担心，Kaseya的桌面迁移模式，会根据你的要求进行数据收集和备份，而且，由于在“桌面迁移”过程中系统的报警程序会自动开启，它会代替你对机器所处的状态进行监控，由于在桌面迁移的各个步骤上都有警示，在Kaseya里面警示会变成报警、标签、电子邮件、或者甚至触发一个代理程序自动运行，这不但使安全性大幅提升，也会使你省下不少力气，所以，放心去做好了。希望可以帮到你！