Re: Dubious server log messages after pg_upgrade

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: Dubious server log messages after pg_upgrade
Дата
Msg-id Z9I3XSM-uJbFSAF-@nathan
обсуждение исходный текст
Ответ на Dubious server log messages after pg_upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Mar 12, 2025 at 08:41:29PM -0400, Tom Lane wrote:
> The "corrupted statistics file" whine is most likely
> caused by pg_upgrade copying the old system's pgstat.stat file
> into the new installation --- is that a good idea?

I don't believe pg_upgrade copies that file to the new cluster.  At least,
that would be news to me.

> I have
> no idea what's causing the redo LSN complaint, but it seems
> like that might deserve closer investigation.

pgstat_read_statsfile() emits a warning before it jumps to the section that
emits the LOG.  The LSN complaint seems to just be providing some context
around what exactly is corrupted in pgstat.stat.  Commit b860848 seems
rather suspect.  I've added Michael here...

-- 
nathan



В списке pgsql-hackers по дате отправления: