PG_DUMPALL
目录
PG_DUMPALL
NAMESYNOPSIS
DESCRIPTION æè¿°
OPTIONS é项
ENVIRONMENT ç¯å¢
NOTES 注æ
EXAMPLES ä¾å
SEE ALSO åè§
è¯è
è·
NAME
pg_dumpall - æ½åºä¸ä¸ª PostgreSQL æ°æ®åºé群å°èæ¬æ件ä¸
SYNOPSIS
pg_dumpall [ option... ]
DESCRIPTION æè¿°
pg_dumpall æ¯ä¸ä¸ªç¨äºååºï¼"转å¨"ï¼ä¸ä¸ªæ°æ®åºé群éçææ PostgreSQL æ°æ®åºå°ä¸ä¸ªèæ¬æ件çå·¥å·ã 该èæ¬æ件åå«å¯ä»¥ç¨äºä½ä¸º psql(1) çè¾å¥æ¢å¤æ°æ®åºçSQLå½ä»¤ã å®éè¿å¯¹æ°æ®åºé群éçæ¯ä¸ªæ°æ®åºè°ç¨ pg_dump(1) å®ç°è¿ä¸ªåè½ã pg_dumpall è¿è½¬å¨åºæææ°æ®åºå¬ç¨çå¨å±å¯¹è±¡ã ï¼pg_dump(1) 并ä¸ä¿åè¿äºå¯¹è±¡ãï¼ è¿äºä¿¡æ¯ç®ååæ¬æ°æ®åºç¨æ·åç»ï¼ä»¥åéç¨äºæ´ä¸ªæ°æ®åºç访é®æéã
å æ¤ï¼pg_dumpall æ¯å¤ä»½ä½ çæ°æ®åºçä¸ä½å解å³æ¹æ¡ã ä½æ¯è¯·æ³¨æå®çå±éæ§ï¼å®æ æ³è½¬å¨"大对象"ï¼å 为 pg_dump æ æ³æè¿æ ·ç对象转å¨å°çº¯ææ¬æ件ä¸ãå¦æä½ çæ°æ®åºéæå¤§å¯¹è±¡ï¼ é£ä¹ä½ åºè¯¥ä½¿ç¨ pg_dump çéææ¬è¾åºæ ¼å¼ä¹ä¸è½¬å¨å®ä»¬ã
å 为 pg_dumpall ä»æææ°æ®åºä¸è¯»åè¡¨ï¼ æä»¥ä½ å¾å¯è½éè¦ä»¥æ°æ®åºè¶çº§ç¨æ·ç身份èæ¥ï¼è¿æ ·æè½çæå®æ´ç转å¨ã åæ ·ï¼ä½ ä¹éè¦è¶çº§ç¨æ·çæéæ§è¡ä¿åä¸æ¥çèæ¬ï¼è¿äºæè½å¢å ç¨æ·åç»ï¼ 以åå建æ°æ®åºã
SQLèæ¬å°ååºå°æ åè¾åºãä½ åºè¯¥ä½¿ç¨åéç shell æä½ç¬¦æå®éå®åå°æ件ã
pg_dumpall éè¦å PostgreSQL æå¡å¨è¿æ¥å¤æ¬¡ï¼å¯è½æ¯æ¬¡é½é®ä½ å£ä»¤ãè¿ç§æåµä¸åä¸ä¸ª $HOME/.pgpass å¯è½ä¼æ¯è¾æ¹ä¾¿ã
OPTIONS é项
ä¸åå½ä»¤è¡åæ°ç¨äºæ§å¶è¾åºæ ¼å¼ï¼
|
-a |
--data-only
åªè½¬å¨æ°æ®ï¼ä¸è½¬å¨æ¨¡å¼ï¼æ°æ®å®ä¹ï¼ã
|
-c |
--clean
åæ¬é£äºé建ä¹åæ¸çï¼å é¤ï¼æ°æ®åºå¯¹è±¡çSQLå½ä»¤ã
|
-d |
--inserts
ææ°æ®å½ä½ INSERT å½ä»¤è¾åºï¼èä¸æ¯ COPYï¼ãè¿æ ·å°ä»¤æ¢å¤è¿ç¨é常ç¼æ¢ï¼ ä½æ¯ä¼ä»¤è¾åºæ´å®¹æ移æ¤å°å¶ä» SQL æ°æ®åºåä¸ã
|
-D |
--column-inserts
--attribute-inserts
ææ°æ®ä»¥æç§å¸¦çæç¡®å段åï¼INSERT INTO table (column, ...) VALUES ...ï¼ç INSERT å½ä»¤å½¢å¼è½¬å¨åºæ¥ã è¿æ ·ä¼ä»¤æ¢å¤é常æ¢ï¼ä½æ¯å¦æéè¦éæå段顺åºå°±æ¯å¿é¡»çã
|
-g |
--globals-only
åªè½¬å¨å¨å±å¯¹è±¡ï¼ç¨æ·åç»ï¼ï¼èä¸è½¬å¨æ°æ®åºã
|
-i |
--ignore-version
å¿½ç¥ pg_dumpall åæ°æ®åºæå¡å¨ä¹é´ççæ¬å·®å«ã
pg_dumpall å¯ä»¥å¤çæ¥èªä»¥åçæ¬ç PostgreSQL çæ°æ®åºï¼ä½æ¯å¤ªèçæ°æ®åºå°±ä¸åæ¯æäºï¼ç®åå° 7.0ï¼ã å¦æä½ éè¦è¦ççæ¬æ£æ¥ï¼é£ä¹å¯ä»¥ä½¿ç¨è¿ä¸ªé项ï¼å¦æ pg_dumpall 失败äºï¼å¯å«è¯´æ们没è¦åä½ ãï¼
|
-o |
||
|
--oids |
为æ¯ä¸ªè¡¨è½¬å¨å¯¹è±¡æ è¯ç¬¦ï¼OIDï¼ã å¦æä½ çåºç¨å¨æç§è§åº¦å¼ç¨äº OID å段ï¼é£ä¹ä½¿ç¨è¿ä¸ªé项 ï¼æ¯å¦ï¼å¨å¤é®çº¦æéï¼ãå¦åï¼ä¸åºè¯¥ä½¿ç¨è¿ä¸ªé项ã
|
-s |
--schema-only
åªè½¬å¨æ¨¡å¼ï¼æ°æ®å®ä¹ï¼ï¼ä¸è½¬å¨æ°æ®ã
|
-v |
--verbose
声æåä½æ¨¡å¼ãè¿æ ·å°ä»¤ pg_dumpall åæ åé误æå°è¿åº¦ä¿¡æ¯ã
|
-x |
--no-privileges
--no-acl
é¿å转å¨è®¿é®æéï¼ææ/æ¤éå½ä»¤ï¼ã
ä¸é¢çå½ä»¤è¡åæ°æ§å¶æ°æ®åºè¿æ¥åæ°ã
-h host
声ææ°æ®åºæå¡å¨æè¿è¡çæºå¨ç主æºåã å¦ææ°å¼ä»¥ææå¼å¤´ï¼é£ä¹å°±æå®ç¨å Unix åå¥æ¥åçç®å½ã 缺çæ¯ä» PGHOST ç¯å¢åééæ¿æ¥çï¼å¦æ设置äºï¼ï¼ å¦åä½¿ç¨ Unix åå¥æ¥åã
-p port
声ææå¡å¨çå¬ç TCP 端å£å·æè Unix åå¥æ¥åæ件æ©å±ã 缺çæ¯ PGPORT ç¯å¢åéï¼å¦æ设置äºï¼ï¼ æèæ¯ç¼è¯æ¶ç缺çã
-U username
以ç»å®ç¨æ·èº«åèæ¥ã
|
-W |
强å¶å£ä»¤æ示ãå¦ææå¡å¨éè¦å£ä»¤è®¤è¯ï¼é£ä¹è¿ä¸ªå¨ä½åºè¯¥èªå¨åçã
ENVIRONMENT ç¯å¢
|
PGHOST |
||
|
PGPORT |
||
|
PGUSER |
缺çè¿æ¥åæ°ã
NOTES 注æ
å 为 pg_dumpall åé¨è°ç¨ pg_dumpï¼æ以ï¼ä¸äºè¯æä¿¡æ¯ å¯ä»¥åè pg_dumpã
æ¢å¤å®ä¹åï¼æ们建议å¨æ¯ä¸ªå·²æ¢å¤ç对象ä¸è¿è¡ ANALYZEã è¿æ ·ä¼åå¨å°±å¯ä»¥å¾å°æç¨çç»è®¡ã ä½ ä¹å¯ä»¥ç¨ vacuumdb -a -z æ¸çæææ°æ®åºã
EXAMPLES ä¾å
转å¨æææ°æ®åºï¼
$ pg_dumpall > db.out
éæ°è½½å¥è¿ä¸ªæ°æ®åºï¼
$ psql -f db.out template1
ï¼å¨è¿éä½ ååªä¸ªæ°æ®åºèæ¥å¹¶ä¸éè¦ï¼å 为 pg_dumpall å建çèæ¬æ件å°åå«åéçå½ä»¤ç¨äºå建åèæ¥ä¿åçæ°æ®åºãï¼
SEE ALSO åè§
pg_dump(1). Check there for details on possible error conditions.
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh