hot_standby_feedback via intermediate replica

Поиск
Список
Период
Сортировка
От Axel Rau
Тема hot_standby_feedback via intermediate replica
Дата
Msg-id BB8FB7F6-B40D-46A7-92DA-077BDD8D9077@Chaos1.DE
обсуждение исходный текст
Ответы Re: hot_standby_feedback via intermediate replica  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-admin
Hi all,

I’m getting:
- - -
pg_dump: error: Error message from server: ERROR:  canceling statement due to conflict with recovery
ClientBeforeJob: DETAIL:  User was holding a relation lock for too long
- - -
I have a 3-level streaming replication setup:
    primary -> standby1 -> standby2
standby2 is for backup only and shows above error.
Both standbys have
    hot_standby_feedback = on
Nvertheless the error happens.
Why?
How can I fix it?

All are running 13.7

Any help appreciated,
Axel
---
PGP-Key: CDE74120  ☀  computing @ chaos claudius




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

Предыдущее
От: "James Pang (chaolpan)"
Дата:
Сообщение: RE: multiple sessions to create index in parallel support
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: hot_standby_feedback via intermediate replica