Re: Catalog corruption

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Re: Catalog corruption
Дата
Msg-id CA+t6e1kN-U3+n-nmBF2roJHP+PQ96pPr3nNJgYBRPxZStBK2ag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Catalog corruption  (Asim R P <apraveen@pivotal.io>)
Список pgsql-hackers
Дерево обсуждения
Yes indeed.
I took a cold backup - shutdown the database and copy all the data dir.

‫בתאריך יום ג׳, 28 באוג׳ 2018 ב-22:34 מאת ‪Asim R P‬‏ <‪apraveen@pivotal.io‬‏>:‬
On Tue, Aug 28, 2018 at 7:36 AM, Mariel Cherkassky
<mariel.cherkassky@gmail.com> wrote:
> Afterwards I vacuumed all the databases but nothing helped. I tried to
> reindex the databases but I got the next error :
>
> 2018-08-28 21:50:03 +08 db2 24360  ERROR:  could not access status of
> transaction 32212695
> 2018-08-28 21:50:03 +08 db2 24360  DETAIL:  Could not open file
> "pg_subtrans/01EB": No such file or directory.
>

Are you sure you created a checkpoint before copying the data
directory over to your PC?

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

Предыдущее
От: Alexander Kukushkin
Дата:
Сообщение: Re: Postmaster doesn't send SIGTERM to bgworker during fast shutdownwhen pmState == PM_STARTUP
Следующее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [HACKERS] advanced partition matching algorithm forpartition-wise join