Re: Unfamiliar recovery message afer server crash
От | Tom Lane |
---|---|
Тема | Re: Unfamiliar recovery message afer server crash |
Дата | |
Msg-id | 25207.1082516875@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Unfamiliar recovery message afer server crash ("Arthur Ward" <award@dominionsciences.com>) |
Список | pgsql-admin |
"Arthur Ward" <award@dominionsciences.com> writes: > Apr 20 11:28:14 postgres: [6203] LOG: database system was not properly > shut down; automatic recovery in progress > Apr 20 11:28:14 postgres: [6203] LOG: redo starts at 7C/CF55FBAC > Apr 20 11:28:17 postgres: [6203] LOG: unexpected pageaddr 7C/C7A0A000 in > log file 124, segment 207, offset 10526720 > Apr 20 11:28:17 postgres: [6203] LOG: redo done at 7C/CFA09F7C > Apr 20 11:28:20 postgres: [6203] LOG: database system is ready > What's the significance of the "unexpected pageaddr" item? Just that the first indication of end-of-XLOG was finding a stale page header in a recycled XLOG file. The above looks fine to me. (The XLOG recovery code tends to err on the side of verboseness... there are a lot of messages it can print that might boggle a novice but are not really indicative of problems.) regards, tom lane
В списке pgsql-admin по дате отправления: