利用管道迁移数据

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

0. Name PIP 0
[pg@h1 ~]$ psql gtlions -ac "select &＃39;t3&＃39; tab,count(*) from t3 union all select &＃39;t4&＃39;,count(*) from t4;"
select &＃39;t3&＃39; tab,count(*) from t3 union all select &＃39;t4&＃39;,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 &＃39;/home/pg/sync&＃39;"|psql gtlions -p 5432 -c "copy t4 from &＃39;/home/pg/sync&＃39;"  
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 &＃39;/home/pg/syncpip&＃39;"|psql gtlions -p 5432 -c "copy t4 from &＃39;/home/pg/syncpip&＃39;"  
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to &＃39;/home/pg/syncpip&＃39;"|psql gtlions -p 5432 -c "copy t4 from &＃39;/home/pg/syncpip&＃39;"        
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to &＃39;/home/pg/syncpip&＃39;"|psql gtlions -p 5432 -c "copy t4 from &＃39;/home/pg/syncpip&＃39;"  
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to &＃39;/home/pg/syncpip&＃39;"|psql gtlions -p 5432 -c "copy t4 from &＃39;/home/pg/syncpip&＃39;"  
COPY 100
[pg@h1 ~]$ psql gtlions -ac "select &＃39;t3&＃39; tab,count(*) from t3 union all select &＃39;t4&＃39;,count(*) from t4;"
select &＃39;t3&＃39; tab,count(*) from t3 union all select &＃39;t4&＃39;,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 &＃39;/home/pg/syncpip&＃39;"|psql gtlions -p 5432 -c "copy t4 from &＃39;/home/pg/syncpip&＃39;"  
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to &＃39;/home/pg/syncpip&＃39;"|psql gtlions -p 5432 -c "copy t4 from &＃39;/home/pg/syncpip&＃39;"  
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to &＃39;/home/pg/syncpip&＃39;"|psql gtlions -p 5432 -c "copy t4 from &＃39;/home/pg/syncpip&＃39;"  
COPY 100
[pg@h1 ~]$ psql gtlions -p 5432 -c "copy t3 to &＃39;/home/pg/syncpip&＃39;"|psql gtlions -p 5432 -c "copy t4 from &＃39;/home/pg/syncpip&＃39;"  
COPY 100
[pg@h1 ~]$ psql gtlions -ac "select &＃39;t3&＃39; tab,count(*) from t3 union all select &＃39;t4&＃39;,count(*) from t4;"
select &＃39;t3&＃39; tab,count(*) from t3 union all select &＃39;t4&＃39;,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 &＃39;/home/pg/syncpip&＃39;"|psql gtlions -p 5432 -c "copy t4 from &＃39;/home/pg/syncpip&＃39;"  
COPY 100
[pg@h1 ~]$ psql gtlions -ac "select &＃39;t3&＃39; tab,count(*) from t3 union all select &＃39;t4&＃39;,count(*) from t4;"                        
select &＃39;t3&＃39; tab,count(*) from t3 union all select &＃39;t4&＃39;,count(*) from t4;
 tab | count
-----+-------
 t3  |   100
 t4  |  1300
(2 rows)