PG_RESTORE
目录
PG_RESTORE
NAMESYNOPSIS
DESCRIPTION æè¿°
OPTIONS é项
ENVIRONMENT ç¯å¢
DIAGNOSTICS è¯æ
NOTES 注æ
EXAMPLES ä¾å
HISTORY åå²
SEE ALSO åè§
è¯è
è·
NAME
pg_restore - ä»ä¸ä¸ªç± pg_dump å建çå¤ä»½æ件ä¸æ¢å¤ PostgreSQL æ°æ®åºã
SYNOPSIS
pg_restore [ option... ] [ filename ]
DESCRIPTION æè¿°
pg_restore æ¯ä¸ç§ç¨äºæ¢å¤ç± pg_dump(1) å建çä»»ä½é纯ææ¬è¾åºæ ¼å¼ä¸ç PostgreSQL æ°æ®åºçåºç¨ã å®å°ååºå¿è¦çå½ä»¤æ¥éæ°æé æ°æ®åºï¼ä»¥ä¾¿äºæå®æ¢å¤æä¿åå®çæ¶åçæ ·åã å½æ¡£ï¼å¤ä»½ï¼æ件è¿å许pg_restore æéæ©å°è¿è¡æ¢å¤ï¼ çè³å¨æ¢å¤åéæ°æåæ¡ç®ç顺åºãå½æ¡£çæ件设计æå¯ä»¥å¨ä¸åç硬件ä½ç³»ä¹é´ç§»æ¤ã
pg_restore å¯ä»¥ä»¥ä¸¤ç§æ¨¡å¼æä½ï¼å¦æ声æäºæ°æ®åºååï¼ é£ä¹å½æ¡£æ¯ç´æ¥æ¢å¤å°æ°æ®åºéã大对象åªè½ç¨ç´æ¥æ°æ®åºèæ¥è¿è¡æ¢å¤ã å¦åï¼åå建ä¸ä¸ªåå«é建æ°æ®åºæå¿é¡»ç SQL å½ä»¤çèæ¬ï¼å¹¶ä¸åå¥å°ä¸ä¸ªæ件æèæ åè¾åºï¼ï¼ 类似 pg_dump è¾åºçº¯ææ¬æ ¼å¼çæ¶åå建çé£ç§èæ¬ã å æ¤ï¼ä¸äºæ§å¶èæ¬è¾åºçé项就æ¯æ¹æ pg_dump çæä½ã
æ¾ç¶ï¼pg_restore æ æ³æ¢å¤é£äºä¸åå¨å½æ¡£æ件ä¸çä¿¡æ¯ï¼ æ¯å¦ï¼å¦æå½æ¡£æ¯ç¨"ææ°æ®è½¬å¨ä¸º INSERTå½ä»¤"é项å¶ä½çï¼ é£ä¹ pg_restore å°ä¸è½ä½¿ç¨ COPY è¯å¥è£è½½æ°æ®ã
OPTIONS é项
pg_restore
æ¥åä¸åå½ä»¤è¡åæ°ã
filename
声æè¦æ¢å¤çå¤ä»½æ件çä½ç½®ãå¦æ没æ声æï¼å使ç¨æ åè¾å¥ã
|
-a |
--data-only
åªæ¢å¤æ°æ®ï¼èä¸æ¢å¤è¡¨æ¨¡å¼ï¼æ°æ®å®ä¹ï¼ã
|
-c |
--clean
å建æ°æ®åºå¯¹è±¡ååæ¸çï¼å é¤ï¼å®ä»¬ã
|
-C |
--create
å¨æ¢å¤æ°æ®åºä¹ååå建å®ãï¼å¦æåºç°äºè¿ä¸ªé项ï¼å -d å¨ä¸èµ·çæ°æ®åºååªæ¯ç¨äºååºæåç CREATE DATABASE å½ä»¤ã æææ°æ®é½æ¢å¤å°åååºç°å¨å½æ¡£ä¸çæ°æ®åºä¸å»ãï¼
-d dbname
--dbname=dbname
ä¸æ°æ®åº dbname èæ¥å¹¶ä¸ç´æ¥æ¢å¤å°è¯¥æ°æ®åºä¸ã
-f filename
--file=filename
声æçæçèæ¬çè¾åºæ件ï¼æèåºç° -l é项æ¶ç¨äºå表çæ件ï¼ç¼ºçæ¯æ åè¾åºã
-F format
--format=format
声æå¤ä»½æ件çæ ¼å¼ãå 为pg_restore ä¼èªå¨å¤æ- æ ¼å¼ï¼æ以å¦æ声æäºï¼å®å¯ä»¥æ¯ä¸é¢ä¹ä¸ï¼
|
t |
å¤ä»½æ¯ä¸ä¸ª tar å½æ¡£ã 使ç¨è¿ä¸ªæ¼å¼å许å¨æ¢å¤æ°æ®åºçæ¶åéæ°æåºå/ææ表模å¼åç´æé¤åºå»ã åæ¶è¿å¯è½å¨æ¢å¤çæ¶åéå¶è£è½½çæ°æ®ã
|
c |
å¤ä»½çæ ¼å¼æ¯æ¥èª pg_dump ç客æ·åæ ¼å¼ã è¿æ¯æçµæ´»çæ¼å¼ï¼å为å®å许éæ°å¯¹æ°æ®æåºï¼ä¹å许é载表模å¼åç´ã 缺çæ¶è¿ä¸ªæ ¼å¼æ¯å缩çã
|
-i |
--ignore-version
忽ç¥æ°æ®åºçæ¬æ£æ¥ã
-I index
--index=index
åªæ¢å¤å½åçç´¢å¼ã
|
-l |
||
|
--list |
ååºå¤ä»½çå容ãè¿ä¸ªæä½çè¾åºå¯ä»¥ç¨ -L é项éå¶åéæææ¢å¤ç项ç®ã
-L list-file
--use-list=list-file
åªæ¢å¤å¨ list-file éé¢çåç´ ï¼ä»¥å®ä»¬å¨æ件ä¸åºç°ç顺åºã ä½ å¯ä»¥ç§»å¨å个è¡å¹¶ä¸ä¹å¯ä»¥éè¿å¨è¡å¼å¤´æ¾ ’;’ çæ¹å¼æ³¨éãï¼è§ä¸æè·åä¾åãï¼
|
-N |
--orig-order
以æåå¨ pg_dump éçæç转å¨é¡ºåºæ¢å¤é¡¹ç®ã è¿ä¸ªé项没æä»ä¹å®éçç¨éï¼å 为 pg_dump ä¼ä»¥èªå·±æ¹ä¾¿ç顺åºçæé¡¹ï¼ è¿ä¸ªé¡ºåºä¸å¯è½æ¯æ¢å¤è¿äºæ°æ®çå®å¨é¡ºåºã ï¼è¿ä¸ªé¡ºåºä¸æ¯é¡¹æåå¨å½æ¡£çå容å表ä¸ååºç顺åºãï¼ åè§ -rã
|
-o |
--oid-order
以 OID 顺åºæ¢å¤é¡¹ç®ãè¿ä¸ªé项ç¨å¤å¾å°ï¼ å 为 OID åªæ¯æåå建顺åºçä¸ä¸ªè¿ä¼¼æ示ã å¦æè¿å£°æäº -Nï¼é£ä¹è¿ä¸ªé项è¿è¦çå®ãåè§ -rã
|
-O |
--no-owner
ä¸è¦è¾åºè®¾ç½®å¯¹è±¡çæéï¼ä»¥ä¾¿ä¸æåçæ°æ®åºå¹éçå½ä»¤ã 缺çæ¶ï¼pg_restore ååº SET SESSION AUTHORIZATION è¯- å¥è®¾ç½®å建åºæ¥ç模å¼åç´ çææèæéã å¦ææåçæ°æ®åºè¿æ¥ä¸æ¯ç±è¶çº§ç¨æ·ï¼æèæ¯æ¥æææå建åºæ¥ç对象çåä¸ä¸ªç¨æ·ï¼åèµ·çï¼é£ä¹è¿äºè¯- å¥å°å¤±è´¥ã ä½¿ç¨ -Oï¼é£ä¹ä»»ä½ç¨æ·é½å¯ä»¥ç¨äºåå§çè¿æ¥ï¼å¹¶ä¸è¿ä¸ªç¨æ·å°æ¥æææå建åºæ¥ç对象ã
-P
function-name(argtype [, ...])
--function=function-name(argtype [, ...])
åªæ¢å¤æå®çå½åå½æ°ã请注æä»ç»æ¼åå½æ°ååå¶åæ°ï¼åºè¯¥å转å¨çå容å表ä¸- çå®å¨ä¸æ ·ã
|
-r |
--rearrange
以对象类åéæ项ç®ï¼è¿ä¸ªåçå¨ä»¥ -N æè -o æåºä¹åï¼ã éææ¯ä¸ºäºç»åºæ大å¯è½çæ§è½ã
å¦æ没æ -N, -o, å-rï¼é£ä¹ pg_restore 以项ç®åºç°å¨å½æ¡£ çå容å表ä¸ç顺åºæ¢å¤ä»ä»¬ï¼ æèæç§ä»ä»¬å¨ list-file éé¢ç顺åºæ¢å¤ä»ä»¬ — åå¦ç»åºäº -L çè¯ã -o å -r çç»åå¤å¶äº pg_dump å¨å建å½æ¡£çå容å表 ä¹åè¿è¡çæåºï¼ å æ- ¤ï¼è¿ä¸ªé项é常没å¿è¦å£°æã
|
-R |
--no-reconnect
è¿ä¸ªé项已ç»åºå¼äºï¼ä½æ¯ä¸ºäºä¿æåä¸å¼å®¹ä»ç¶æ¥åã
|
-s |
--schema-only
åªæ¢å¤è¡¨ç»æï¼æ°æ®å®ä¹ï¼ãä¸æ¢å¤æ°æ®ï¼åºåå¼å°éç½®ã
-S username
--superuser=username
设置å³é触åå¨æ¶å£°æè¶çº§ç¨æ·çç¨æ·åã åªæå¨è®¾ç½®äº --disable-triggers çæ¶åææç¨ã
-t table
--table=table
åªæ¢å¤è¡¨æå®ç表çå®ä¹å/ææ°æ®ã
-T trigger
--trigger=trigger
åªæ¢å¤æå®ç触åå¨ã
|
-v |
--verbose
声æåä½æ¨¡å¼ã
|
-x |
--no-privileges
--no-acl
é¿å ACL çæ¢å¤ï¼grant/revoke å½ä»¤ï¼ã
-X
use-set-session-authorization
--use-set-session-authorization
è¿ä¸ªé项已ç»åºå¼äºï¼ä½æ¯åºäºåä¸å¼å®¹ï¼ä»ç¶æ¥åã pg_restore ç°å¨æ»æ¯è¡¨ç°å¾å以åéä¸è¿ä¸ªé项ä¸æ ·ã
-X disable-triggers
--disable-triggers
è¿ä¸ªé项åªæå¨æ§è¡ä»æ¢å¤æ°æ®çæ¶åæç¸å³ãå®åè¯ pg_restore å¨è£è½½æ°æ®çæ¶åæ§è¡ä¸äºå½ä»¤ä¸´æ¶å³éå¨ç®æ 表ä¸ç触åå¨ã å¦æä½ å¨è¡¨ä¸æå®æ´æ§æ£æ¥æèå¶å®è§¦åå¨ï¼ èä½ åä¸å¸æå¨è£è½½æ°æ®çæ¶åæ¿æ´»å®ä»¬ï¼é£ä¹å¯ä»¥ä½¿ç¨è¿ä¸ªé项ã
ç®åï¼ä¸º --disable-triggers ååºçå½ä»¤å¿é¡»ä»¥è¶çº§ç¨æ·ååºã å æ- ¤ï¼ä½ åºè¯¥ä¹è¦ç¨ -S 声æä¸ä¸ªè¶çº§ç¨æ·åï¼æèæ´å¥½æ¯è®¾ç½® --use-set-session-authorization 并ä¸ä»¥ PostgreSQL è¶çº§ç¨æ·èº«ä»½è¿è¡ pg_restoreã
pg_restore
è¿æ¥åä¸é¢çå½ä»¤è¡åæ°å为èæ¥åæ°ï¼
-h host
--host=host
声ææå¡å¨è¿è¡çæºå¨ç主æºåã å¦ææ°å¼ä»¥ææå¼å¤´ï¼é£ä¹å®è¢«ç¨å Unix åå¥æ¥åçç®å½ã 缺çæ¯ä» PGHOST ç¯å¢åéä¸è·åçï¼å¦æ设置äºï¼ï¼ å¦åå°å°è¯è¿è¡ Unix åå¥æ¥åã
-p port
--port=port
声ææå¡å¨ä¾¦å¬ç TCP 端å£æèæ¬å°ç Unix åå¥æ¥åæ件æ©å±ã 缺çæ¯ç¯å¢åé PGPORT çå¼ï¼å¦æ设置äºçè¯ï¼ï¼ å¦å就说ç¼è¯ç缺çã
-U username
以ç»åºç¨æ·èº«åèæ¥ã
|
-W |
强å¶ç»åºå£ä»¤æ示ãå¦ææå¡å¨è¦æ±å£ä»¤è®¤è¯ï¼é£ä¹è¿ä¸ªåºè¯¥èªå¨åçã
ENVIRONMENT ç¯å¢
|
PGHOST |
||
|
PGPORT |
||
|
PGUSER |
缺çè¿æ¥åæ°ã
DIAGNOSTICS è¯æ
å½ä½¿ç¨-dé项声æäºç´æ¥æ°æ®åºèæ¥æ¶ï¼ pg_restore å¨åé¨æ§è¡ SQL è¯- å¥ãå¦æä½ è¿è¡ pg_restore åºäºæ¯çï¼ è¯·ç¡®ä¿ä½ è½ç¨ç±»ä¼¼ psql(1) è¿æ ·çä¸è¥¿ä»æ°æ®åºä¸éåä¿¡æ¯ã
NOTES 注æ
å¦æä½ çå®è£ç»template1æ°æ®åºå¢å äºä»»ä½ä½ èªå·±çä¸è¥¿ï¼ é£ä¹è¯·æ³¨ææ pg_dump çè¾åºæ¢å¤å°ä¸ä¸ªçæ£ç©ºçæ°æ®åºä¸ï¼ å¦åä½å¯è½ä¼æ¶å°å为éå¤å®ä¹æ追åç对象èéæçé误信æ¯ãè¦å¶ä½ä¸ä¸ªæ²¡æä»»ä½æ¬å°éå±ç©çæ°æ®åºï¼ å¯ä»¥ä»template0èä¸æ¯template1æ·è´ï¼æ¯å¦ï¼
CREATE DATABASE foo WITH TEMPLATE template0;
pg_restore çå±éå¨ä¸é¢ååºã
|
• |
å½åä¸ä¸ªå·²ç»åå¨ç表æ¢å¤æ°æ®ï¼å¹¶ä¸è¿ä½¿ç¨äº --disable-triggers é项æ¶ï¼ pg_restore å¨æå¥æ°æ®åæ¾åºä¸äºæ¥è¯¢å³éç¨æ·è¡¨ä¸ç触åå¨ï¼ å¨æ°æ®æå¥å®æåéæ°æå¼å®ä»¬ãå¦ææ¢å¤çä¸éåæ¢ï¼é£ä¹ç³»ç»è¡¨å¯è½å¤äºé误ç¶æã
|
• |
pg_restore å°ä¸ä¼ä¸ºåä¸ç表æ¢å¤å¤§å¯¹è±¡ã å¦æä¸ä¸ªå½æ¡£åå«å¤§å¯¹è±¡ï¼é£ä¹ææ大对象é½å°è¢«æ¢å¤ã |
åè§åé pg_dump(1) çææ¡è·åæå³ pg_dump çå±éçç»èã
ä¸æ¦å®ææ¢å¤ï¼æ好å¨æ¯ä¸ªæ¢å¤ç对象ä¸è¿è¡ ANALYZEï¼ ä»¥ä¾¿ç»ä¼åå¨æç¨çç»è®¡ã
EXAMPLES ä¾å
æä¸ä¸ªåå«å¤§å¯¹è±¡çå« mydb çæ°æ®åºè½¬å¨å°ä¸ä¸ªtaræ件ï¼
$ pg_dump -Ft -b mydb > db.tar
æè¿ä¸ªæ°æ®åºæ¢å¤å°ç°æçå« newdb çæ°æ®åºä¸ï¼è¿åBLOBï¼ï¼
$ pg_restore -d newdb db.tar
è¦å¯¹é¡¹ç®éæ°æåºï¼é¦åå¿é¡»è½¬å¨å½æ¡£çç®å½ï¼
$ pg_restore -l archive.file > archive.list
è¿ä¸ªæ件ç±ä¸è¡å¤´åæ¯ä¸ªé¡¹ç®ä¸è¡ç»æï¼æ¯å¦ã
;
; Archive created at Fri Jul 28 22:28:36 2000
; dbname: birds
; TOC Entries: 74
; Compression: 0
; Dump Version: 1.4-0
; Format: CUSTOM
;
;
; Selected TOC Entries:
;
2; 145344 TABLE species postgres
3; 145344 ACL species
4; 145359 TABLE nt_header postgres
5; 145359 ACL nt_header
6; 145402 TABLE species_records postgres
7; 145402 ACL species_records
8; 145416 TABLE ss_old postgres
9; 145416 ACL ss_old
10; 145433 TABLE map_resolutions postgres
11; 145433 ACL map_resolutions
12; 145443 TABLE hs_old postgres
13; 145443 ACL hs_old
è¿éåå·æ¯æ³¨éåé符ï¼èè¡å¼å¤´çæ°å代表èµç»æ¯ä¸ªé¡¹ç®çåé¨å½æ¡£ IDã
æ件åçè¡å¯ä»¥æ³¨éæï¼å é¤å/æéæ°æåãæ¯å¦ï¼
10; 145433 TABLE
map_resolutions postgres
;2; 145344 TABLE species postgres
;4; 145359 TABLE nt_header postgres
6; 145402 TABLE species_records postgres
;8; 145416 TABLE ss_old postgres
å¯ä»¥ç¨å pg_restore çè¾å¥å¹¶ä¸åªä¼æ¢å¤é¡¹ç® 10 å 6ï¼ï¼ä»¥è¿ä¸ªé¡ºåºï¼ï¼
$ pg_restore -L archive.list archive.file
HISTORY åå²
pg_restore å·¥å·ç¬¬ä¸æ¬¡åºç°å¨ PostgreSQL 7.1ã
SEE ALSO åè§
pg_dump(1), pg_dumpall(1), psql(1)
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh