Re: [ADMIN] could not access status of transaction

Поиск
Список
Период
Сортировка
От Ashish Tiwari
Тема Re: [ADMIN] could not access status of transaction
Дата
Msg-id CAH8UkmGGps7gVzT_teENb=28iD3kDFfQic4Vwn6MkDnn2xzQtw@mail.gmail.com
обсуждение исходный текст
Ответ на [ADMIN] could not access status of transaction  (Harsh Patel <harshpatel19@gmail.com>)
Список pgsql-admin
Дерево обсуждения
Can you share your environment details.it seems WAL file is discarded before copying on slave.

On Jul 12, 2017 7:14 PM, "Harsh Patel" <harshpatel19@gmail.com> wrote:
While configuring streaming replication on master(master already had 200gb data), I added the following changes
wal_level = hot_standby
max_wal_senders = 3
wal_keep_segments = 8

and restarted postgres.

I started getting error
could not access status of transaction 243368097
Could not open file "pg_multixact/members/433B": No such file or directory.

What steps should I take to recover from this.

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

Предыдущее
От: Harsh Patel
Дата:
Сообщение: [ADMIN] could not access status of transaction
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: [ADMIN] autovacuum logs question