Re: Check for logical / physical corruption

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Check for logical / physical corruption
Дата
Msg-id 1516898257.2599.17.camel@cybertec.at
обсуждение исходный текст
Ответ на Check for logical / physical corruption  (flumbador@virgilio.it)
Список pgsql-admin
flumbador@virgilio.it wrote:
> I need to check that my database has not physical / logical corruption.
> I think that "vacuumdb -all -freeze -analyze" will do this for me.
> Am I right? 
> Are there other command / utility that I should do to check corruptions?

The only good test is to run a pg_dumpall and restore the dump into a new
PostgreSQL cluster.

Yours,
Laurenz Albe


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

Предыдущее
От: flumbador@virgilio.it
Дата:
Сообщение: Check for logical / physical corruption
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Upgrade and re-synchronization with logical replication(pglogical and PG 10)