PG_CTL
目录
PG_CTL
NAMESYNOPSIS
DESCRIPTION æè¿°
OPTIONS é项
ENVIRONMENT ç¯å¢
FILES æ件
NOTES 注æ
EXAMPLES ä¾å
STARTING THE SERVER å¯å¨æå¡å¨
STOPPING THE SERVER åæ¢æå¡å¨
RESTARTING THE SERVER éèµ·æå¡å¨
SHOWING THE SERVER STATUS æ¾ç¤ºæå¡å¨ç¶æ
SEE ALSO åè§
è¯è
è·
NAME
pg_ctl - å¯å¨ï¼åæ¢åéå¯ PostgreSQL æå¡å¨
SYNOPSIS
pg_ctl start [ -w ] [ -s ] [ -D datadir ] [ -l filename ] [ -o options ] [ -p path ]
pg_ctl stop [ -W ] [ -s ] [ -D datadir ] [ -m s[mart] | f[ast] | i[mmediate] ]
pg_ctl restart [ -w ] [ -s ] [ -D datadir ] [ -m s[mart] | f[ast] | i[mmediate] ] [ -o options ]
pg_ctl reload [ -s ] [ -D datadir ]
pg_ctl status [ -D datadir ]
DESCRIPTION æè¿°
pg_ctl æ¯ä¸ä¸ªç¨äºå¯å¨ï¼åæ¢ï¼ æèéèµ· PostgreSQL å端æå¡å¨ï¼postmasterï¼ï¼ æèæ¾ç¤ºä¸ä¸ªè¿è¡ççæå¡å¨çç¶æçå·¥å·ï¼ 尽管æ们å¯ä»¥æå¨å¯å¨æå¡å¨ï¼ä½æ¯ pg_ctl å°è£äºéæ°å®åæ¥å¿è¾åºï¼ ä¸ç»ç«¯åè¿ç¨ç»åçå离ï¼ä»¥åå¦å¤æä¾äºä¸ä¸ªé项ç¨äºææ§å¶çå³éã
å¨ start 模å¼éä¼å¯å¨ä¸ä¸ªæ°çæå¡å¨ã æå¡å¨æ¯å¨åå°å¯å¨çï¼æ åè¾å¥è¢«éçå°äº /dev/null ä¸ãå¦æ使ç¨äº -lï¼é£ä¹æ åè¾åºåæ åé误被å®åå°ä¸ä¸ªæ¥å¿æä»¶ï¼ è¦ä¹å°±æ¯éæ°å®åå° pg_ctl çæ åè¾åºï¼èä¸æ¯æ åé误ï¼ã å¦æ没æéå®æ¥å¿æ件ï¼pg_ctl çæ åè¾åºåºè¯¥éæ°å®åå°ä¸ä¸ªæ件æèç¨ç®¡éè¾åºå°å¦å¤ä¸ä¸ªè¿ç¨ï¼ æ¯å¦é£äºæ¥å¿æ转ç¨åºï¼å¦åï¼postmaster å°æå®çè¾åºåå°æ§å¶ç»ç«¯ï¼å¨åå°ï¼å¹¶ä¸å°ä¸ä¼è±ç¦» shell çè¿ç¨ç»ã
å¨ stop 模å¼ä¸ï¼é£ä¸ªæ£å¨ç¹å®æ°æ®ç®å½è¿è¡çæå¡å¨è¢«å³éã ä½ å¯ä»¥ç¨ -m é项éæ©ä¸ç§ä¸åçå³é模å¼ï¼"Smart" 模å¼çå¾ææ客æ·ç«¯ä¸æèæ¥ã è¿ä¸ªæ¯ç¼ºçã"Fast" 模å¼å¹¶ä¸çå¾å®¢æ·ç«¯ä¸æèæ¥ã æææ´»è·äºå¡é½è¢«åå·å¹¶ä¸å®¢æ·ç«¯é½å¼ºå¶æå¼ã "Immediate" 模å¼å°å¨æ²¡æå¹²åå³éçæåµä¸éåºãè¿ä¹åå°å¯¼è´å¨éæ°å¯å¨çæ¶åçæ¢å¤ã
restart å®éä¸æ¯åæ§è¡ä¸ä¸ªåæ¢ï¼ç¶åç´§è·ä¸ä¸ªå¯å¨ãå®å许åæ¢ postmaster å½ä»¤è¡çé项ã
reload 模å¼ç®åå°ç» postmaster åéä¸ä¸ª SIGHUP ä¿¡å·ï¼å¯¼è´å®éæ°è¯»å她çéç½®æ件 ï¼postgresql.conf, pg_hba.conf ççï¼ è¿æ ·å°±å许修æ¹éç½®æ件é项èä¸ç¨å®å¨éå¯ç³»ç»æ¥ä½¿ä¹çæã
status 模å¼çæ¥ä¸ä¸ªæå¡å¨æ¯å¦å¨æå®çæ°æ®ç®å½è¿è¡ï¼ å¦ææ¯ï¼é£ä¹æ¾ç¤ºå¶ PID åè°ç¨å®çå½ä»¤è¡é项ã
OPTIONS é项
-D datadir
声æ该æ°æ®åºæ件çæ件系ç»ä½ç½®ã å¦æ忽ç¥è¿ä¸ªé项ï¼ä½¿ç¨ç¯å¢åé PGDATAã
-l filename
ææå¡å¨æ¥å¿è¾åºéå å¨ filename æ件ä¸ã å¦æ该æ件ä¸å- å¨ï¼é£ä¹å建å®ãumask设置为 077ï¼ å æ- ¤ç¼ºçæ¶æ¯ä¸å许ä»å¶å®ç¨æ·åæ¥å¿æ件访é®çã
-m mode
声æå³é模å¼ãmode å¯ä»¥æ¯smart, fast, æè immediateï¼æèæ¯è¿ä¸ä¸ªä¹ä¸ç第ä¸ä¸ªåæ¯ã
-o options
声æè¦ç´æ¥ä¼ éç» postmaster çé项ã
åæ°é常é½ç¨åæèåå¼å·åå´ä»¥ä¿è¯å®ä»¬ä½ä¸ºä¸ä¸ªæ´ä½ä¼ éã
-p path
声æ postmaster å¯æ§è¡æ件çä½ç½®ã 缺çæ¶ postmaster æ¯ä»å pg_ctl ç¸åçç®å½ååºï¼å¦æä¸æ¯ï¼ é£ä¹å°±æ¯åæ- »çå®è£ç®å½ãé¤éä½ æ³å¹²ç¹ä»ä¹ç¹å«çäºæï¼å¹¶ä¸å¾å°ç±»ä¼¼æ²¡ææ¾å° postmasterè¿æ ·çéè¯¯ï¼ å¦å没æå¿è¦ä½¿ç¨è¿ä¸ªé项ã
|
-s |
åªæå°é误ï¼èä¸æå°æ示æ§ä¿¡æ¯ã
|
-w |
çå¾å¯å¨æèå³éçå®æãå¨ 60 ç§åè¶æ¶ã è¿ä¸ªåæ°æ¯å³éæ¶ç缺çå¼ã æåçå³é- æ¯ä»¥å é¤ PID æ件为æ å¿çã对äºå¯å¨èè¨ï¼ ä¸æ¬¡æåç psql -l å°±æ å¿çæåã pg_ctl å°è§å¾ä½¿ç¨å¯¹ psql åéç端å£ï¼å¦æåå¨ç¯å¢åé PGPORTï¼é£ä¹ç¨å®ã å¦åï¼å®å°æ¥æ¾ççå¨ postgresql.conf æ件éé¢æ¯å¦è®¾ç½®äºä¸ä¸ªç«¯å£ã å¦æé½æ²¡æï¼å®å°ä½¿ç¨ PostgreSQL ç¼è¯æ¶ç缺ç端å£ï¼ç¼ºçæ¯ 5432ï¼ã
|
-W |
ä¸çå¾å¯å¨æèåæ¢çå®æãè¿æ¯å¯å¨åéèµ·ç缺çã
ENVIRONMENT ç¯å¢
|
PGDATA |
缺çæ°æ®ç®å½ä½ç½®
|
PGPORT |
psql(1) ç缺ç端å£ï¼ç± -w é项使ç¨ï¼ã |
å¶å®çç¯å¢åéï¼åé postmaster(1).
FILES æ件
postmaster.pid
è¿ä¸ªæ件åå¨äºæ°æ®ç®å½ä¸æ¯ä¸ºäºå¸®å© pg_ctl å¤æ- æå¡å¨å½åæ¯å¦å¨è¿è¡ã
postmaster.opts.default
å¦æè¿ä¸ªæ件åå¨äºæ°æ®ç®å½ï¼pg_ctlï¼å¨ start 模å¼ä¸ï¼å°ææ件å°å容å½ä½ä¼ éç» postmaster å½ä»¤çéé¡¹ä¼ éè¿å»ï¼é¤é被 -o é项è¦çã
postmaster.opts
å¦æè¿ä¸ªæ件åå¨äºæ°æ®ç®å½ï¼pg_ctlï¼å¨ start 模å¼ä¸ï¼å°ææ件å°å容å½ä½ä¼ éç» postmaster å½ä»¤çéé¡¹ä¼ éè¿å»ï¼é¤é被 -o é项è¦çãè¿ä¸ªæ件çå容ä¹ä¼å¨ status 模å¼éæ¾ç¤ºåºæ¥ã
postgresql.conf
è¿ä¸ªæ件å¨æ°æ®ç®å½ä¸ï¼ä¼åæå®ä»¥æ¥æ¾å psql ä¸èµ·ç¨çåéç端å£ï¼å¨ start 模å¼éç»åº -w çæ¶åãï¼
NOTES 注æ
çå¾å®å¨å¯å¨è¿ä¸æ¯ä¸ä¸ªå®ä¹å¾å¾å®æ´çæä½ï¼ å¦æ访é®æ§å¶è®¾ç½®ä¸ºæ¬å°å®¢æ·ç«¯å¨æ²¡ææ工交äºçæåµä¸ä¸è½è®¿é®çè¯è¿å¯è½ä¼å¤±æãï¼æ¯å¦ï¼å£ä»¤è®¤è¯ï¼ã
EXAMPLES ä¾å
STARTING THE SERVER å¯å¨æå¡å¨
å¯å¨æå¡å¨ï¼
$ pg_ctl start
å¯å¨æå¡å¨çä¸ä¸ªä¾åï¼ çå°æå¡å¨ å¯å¨äºæéåºï¼
$ pg_ctl -w start
ç¨äºä¸ä¸ª postmaster 使ç¨ç«¯å£ 5433ï¼èä¸ä¸å¸¦ fsync è¿è¡ï¼ä½¿ç¨ï¼
$ pg_ctl -o "-F -p 5433" start
STOPPING THE SERVER åæ¢æå¡å¨
$ pg_ctl stop
åæ¢æå¡å¨ï¼ä½¿ç¨ -m å¼å³å许æ们æ§å¶å¦ä½æå端åä¸æ¥ã -wçå¾æå¡å¨åæ¢ã-m 声æå端çåæ¢æ¨¡å¼ã
RESTARTING THE SERVER éèµ·æå¡å¨
è¿ä¸ªå½ä»¤å ä¹çäºååæ¢ postmaster ç¶ååå¯å¨å¥¹ï¼åªä¸è¿ pg_ctl ä¿å- 并éæ°ä½¿ç¨ä¸ä¸æ¬¡è¿è¡ postmaster çå½ä»¤è¡åæ°ãéèµ·æå¡å¨çæç®åçæ¹æ³æ¯ï¼
$ pg_ctl restart
éèµ·æå¡å¨ï¼çå¾å¶åæ¢åéèµ·ï¼
$ pg_ctl -w restart
ä½¿ç¨ 5433 é起并ä¸éèµ·åå³é fsyncï¼
$ pg_ctl -o "-F -p 5433" restart
SHOWING THE SERVER STATUS æ¾ç¤ºæå¡å¨ç¶æ
ä¸é¢æ¯æ¥èª pg_ctl çç¶æè¾åºçä¾åï¼
$ pg_ctl
status
pg_ctl: postmaster is running (pid: 13718)
Command line was:
/usr/local/pgsql/bin/postmaster ’-D’
’/usr/local/pgsql/data’ ’-p’
’5433’ ’-B’ ’128’
è¿æ¯å¨é起模å¼é使ç¨çå½ä»¤è¡ã
SEE ALSO åè§
postmaster(1)
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh