利用管道遷移資料,管道遷移資料
磁碟空間不足的情況下,利用命名或者匿名管道遷移和匯入資料;需要注意具名管道的許可權問題。
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 syncpipprw-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 IT管理技術中的“案頭遷移”有無資料丟失風險?
這點你完全不用擔心,Kaseya的案頭移轉模式,會根據你的要求進行資料收集和備份,而且,由於在“案頭遷移”過程中系統的警示程式會自動開啟,它會代替你對機器所處的狀態進行監控,由於在案頭遷移的各個步驟上都有警示,在Kaseya裡面警示會變成警示、標籤、電子郵件、或者甚至觸發一個代理程式自動運行,這不但使安全性大幅提升,也會使你省下不少力氣,所以,放心去做好了。希望可以幫到你!