當(dāng)前位置:首頁(yè) >  站長(zhǎng) >  數(shù)據(jù)庫(kù) >  正文

Postgresql 解決pg掉電后無(wú)法重啟的問(wèn)題

 2021-06-03 17:29  來(lái)源: 腳本之家   我來(lái)投稿 撤稿糾錯(cuò)

  域名預(yù)訂/競(jìng)價(jià),好“米”不錯(cuò)過(guò)

機(jī)房斷電后重啟pg數(shù)據(jù)庫(kù),報(bào)如下錯(cuò)誤:

< 2019-01-01 22:42:59.240 EST >LOG: database system was interrupted while in recovery at 2019-01-01 22:00:58 EST
< 2019-01-01 22:42:59.240 EST >HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
< 2019-01-01 22:42:59.241 EST >LOG: database system was not properly shut down; automatic recovery in progress
< 2019-01-01 22:42:59.333 EST >PANIC: unexpected pageaddr 26EA/46000000 in log segment 00000001000026EA00000017, offset 0
< 2019-01-01 22:42:59.333 EST >LOG: startup process (PID 88586) was terminated by signal 6: Aborted
< 2019-01-01 22:42:59.333 EST >LOG: aborting startup due to startup process failure

 

修復(fù)方法:

切換到bin目錄下:

1cd /usr/pgsql-9.3/bin

使用pg_resetxlog命令修復(fù)日志:(/var/lib/pgsql/9.3/data為pg_data的目錄)

1pg_resetxlog -f /var/lib/pgsql/9.3/data

重啟數(shù)據(jù)庫(kù):

1pg_ctl start

補(bǔ)充:PostgreSQL 數(shù)據(jù)庫(kù)服務(wù)無(wú)法啟動(dòng)的解決方法

因?yàn)榭蛻?hù)那邊的磁盤(pán)一般是FAT32的文件系統(tǒng),所以我們程序安裝時(shí),采用手動(dòng)安裝PostgreSQL的形式安裝數(shù)據(jù)庫(kù),但初始化數(shù)據(jù)庫(kù)群成功并且成功注冊(cè)了系統(tǒng)服務(wù)后,

發(fā)現(xiàn)PostgreSQL的服務(wù)總是啟動(dòng)不了,提示服務(wù)啟動(dòng)又停止了,然后在系統(tǒng)時(shí)間查看器里發(fā)現(xiàn)報(bào)的錯(cuò)誤是:Could not create inherited socket, 錯(cuò)誤編碼為10022

解決方法:

運(yùn)行 netsh winsock reset,重啟電腦,OK!

文章來(lái)源:腳本之家

來(lái)源地址:https://www.jb51.net/article/204287.htm

申請(qǐng)創(chuàng)業(yè)報(bào)道,分享創(chuàng)業(yè)好點(diǎn)子。點(diǎn)擊此處,共同探討創(chuàng)業(yè)新機(jī)遇!

相關(guān)文章

熱門(mén)排行

信息推薦