PG_RESETXLOG

中文man手册

目录

NAME pg_resetxlog
SYNOPSIS .sp
DESCRIPTION 描述
NOTES 注意
译者
跋

PG_RESETXLOG

NAME
SYNOPSIS
DESCRIPTION æè¿°
NOTES æ³¨æ
è¯è
è·

NAME

pg_resetxlog - éç½®ä¸ä¸ª PostgreSQL æ°æ®åºéç¾¤çé¢åæ¥å¿ä»¥åå¶å®æ§å¶åå®¹

SYNOPSIS

pg_resetxlog [ -f ] [ -n ] [ -o oid ] [ -x xid ] [ -l fileid,seg ] datadir

DESCRIPTION æè¿°

pg_resetxlog æ¸çé¢åæ¥å¿ï¼WALï¼å¹¶ä¸å¯ä»¥éæ©å°éç½®å¶å®ä¸äºæ§å¶ä¿¡æ¯ï¼å- å¨å¨ pg_control æä»¶ä¸ï¼ã ææ¶åï¼å¦æè¿äºæä»¶å´©æºäºï¼æä»¬éè¦è¿ä¸ªåè½ã æä»¬ä¸å®åªæå®ç¨ä½æåçæ¹æ³ï¼å°±æ¯è¯´åªæåä¸ºè¿æ·çå´©æºå¯¼è´æå¡å¨ææ³å¯å¨çæ¶åæä½¿ç¨ã

å¨è¿è¡è¿ä¸ªå½ä»¤ä¹åï¼æä»¬å¯è½å¯ä»¥å¯å¨æå¡å¨äºï¼ä½æ¯ï¼ä¸å®è¦è®°ä½æ°æ®åºå¯è½åä¸ºé¨åæäº¤çäºå¡èå«æä¸å®æ´çæ°æ®ã ä½ åºè¯¥é©¬ä¸è½¬å¨ä½ çæ°æ®ï¼è¿è¡ initdbï¼ç¶åéæ°è£è½½ã å¨éæ°è£è½½ä¹åï¼æ£æ¥ä¸å®æ´çé¨åç¶åæ ¹æ®éè¦è¿è¡ä¿®å¤ã

è¿ä¸ªå½ä»¤åªè½ç±å®è£æå¡å¨çç¨æ·è¿è¡ï¼å ä¸ºå®éè¦å¯¹æ°æ®ç®å½çè¯»åæéã åºäºå®å¨èèï¼ä½ å¿é¡»å¨å½ä»¤è¡ä¸å£°ææ°æ®ç®å½ã pg_resetxlog ä¸ä½¿ç¨ç¯å¢åé PGDATAã

å¦æ pg_resetxlog æ±æ¨è¯´å®æ æ³å¤æç¨äº pg_control çæææ°æ®ï¼é£ä¹ä½ å¯ä»¥å¼ºå¶å®ç»§ç»å¤çï¼ æ¹æ³æ¯å£°æ -f ï¼å¼ºå¶ï¼å¼å³ãå¨è¿ç§æåµä¸ï¼é£äºä¸¢å¤±äºçæ°æ®çå¼å°ç¨æ¨¡ç³çè¿ä¼¼æ°å¼ä»£æ¿ã å¤§å¤æ°åæ®µé½å¯ä»¥å¹éä¸ï¼ä½æ¯ä¸ä¸ä¸ª OIDï¼ä¸ä¸ä¸ªäºå¡ IDï¼WAL å¼å§å°åä»¥åæ°æ®åºåºååæ®µå¯è½éè¦æå·¥å¸®å©ï¼ åé¢ä¸ä¸ªå¯ä»¥ç¨ä¸é¢è®¨è®ºçå¼å³è®¾ç½®ãpg_resetxlog èªå·±çç¯å¢æ¯çæµåºåå- æ®µçæ¥æºï¼çç LANG ççä¸è¥¿ï¼å®ä»¬åºè¯¥å initdb è¿è¡çç¯å¢ç¸å¹éã å¦æä½ ä¸è½å¤æææè¿äºåæ®µçæ£ç¡®æ°å¼ï¼é£ä¹è¿æ¯å¯ä»¥ä½¿ç¨ -fï¼ ä½æ¯è¿æ ·æ¢å¤è¿æ¥çæ°æ®åºæ´è¦æçæé®é¢ï¼ç«å³è½¬å¨åéç½®æ¯å¿é¡»çã å¨è½¬å¨ä¹åä¸è¦æ§è¡ä»»ä½ä¿®æ¹æ°æ®çæä½ï¼åä¸ºä»»ä½è¿æ·çå¨ä½é½å¯è½æäºææå¾æ´ç³ç³ã

-o, -x, å -l å¼å³åè®¸æä»¬æå·¥è®¾ç½®ä¸ä¸ä¸ª OIDï¼ä¸ä¸ä¸ªäºå¡ IDï¼ä»¥å WAL èµ·å§ä½ç½®çæ°å¼ã åªæå¨ pg_resetxlog æ æ³éè¿è¯»å pg_control å¤æ- åéçæ°å¼çæ¶åæéè¦å®ãå¯¹äºä¸ä¸ä¸ªäºå¡ ID èè¨ï¼ä¸ä¸ªå®å¨çæ°å¼æ¯ççæ°æ®ç®å½éç /pg_clog éæ°å¼æå¤§çæä»¶åï¼ ç¶åå ä¸ï¼ç¶ååä¹ä¸ 1048576ãè¯·æ³¨æé£äºæä»¶åæ¯ååè¿å¶çãéå¸¸æä»¬ä¹ä»¥åå- è¿å¶çå½¢å¼å£°æå¼å³å¼æ¯æç®åå¾ã æ¯å¦ï¼å¦æ 0011 æ¯ pg_clog é æå¤§çè®°å½ï¼-x 0x1200000 å°±å¯ä»¥äºï¼åé¢çäºä¸ªé¶æä¾äºåéçä¹ç§¯ï¼ã WAL çèµ·å§ä½ç½®åºè¯¥æ¯ç®ååå¨äºæ°æ®ç®å½éå¾ /pg_xlog éé¢çä»»ä½æä»¶å·é½å¤§ãå®ä¹æ¯ååè¿å¶çï¼å¹¶ä¸æä¸¤é¨åãæ¯å¦ï¼å¦æ 000000FF0000003A æ¯ pg_xlog éæå¤§çæ¡ç®ï¼ é£ä¹-l 0xFF,0x3B å°±å¯ä»¥äºãæä»¬æ²¡æå¾å®¹æçåæ³æ¥å¤ææ¯æ°æ®åºä¸æå¤§ç OID å¤§ä¸å·çä¸ä¸ä¸ª OIDï¼ ä¸è¿å¾èµ°è¿çæ¯è·åæ£ç¡®çä¸ä¸ä¸ª OID å¹¶ééå¸¸å³é®ã

å¼å³ -n ï¼æ æä½ï¼æç¤º pg_resetxlog æå°ä» pg_control éæ°æé çæ°å¼ç¶åä¸ä¿®æ¹ä»»ä½å¼å°±éåºã è¿ä¸»è¦æ¯ä¸ä¸ªè°è¯å·¥å·ï¼ä½æ¯å¨ pg_resetxlog çæ£å¤çåè¿è¡çæ´æ´æ§æ£æ¥çæ¶åå¯è½ä¼æç¨ã

NOTES æ³¨æ

å¨ postmaster æå¡å¨è¿è¡çæ¶åä¸å®ä¸è¦è¿è¡è¿ä¸ªå½ä»¤ã å¦æåç°å¨æ°æ®æä»¶ç®å½éæéæä»¶ï¼é£ä¹ pg_resetxlog å°æç»å¯å¨ãå¦æ postmaster å´©æºï¼é£ä¹å¯è½ä¼å©ä¸ä¸ä¸ªéæä»¶ï¼ å¦æè¿æ ·ï¼ä½ å¯ä»¥å é¤è¯¥éæä»¶ä»¥ä¾¿åè®¸ pg_resetxlog è¿è¡ãä½æ¯å¨ä½è¿ä¹åä¹åï¼ä¸å®è¦ç¡®ä¿¡æ²¡æä»»ä½postmasteræèåç«¯æå¡å¨ä»å¨è¿è¡ã

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æåé¡µè®¡åæä¾ã
ä¸æ man æåé¡µè®¡åï¼https://github.com/man-pages-zh/manpages-zh

↑