hot_standby_feedback via intermediate replica

From: Axel Rau <Axel(dot)Rau(at)Chaos1(dot)DE>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: hot_standby_feedback via intermediate replica
Date: 2022-06-23 08:59:28
Message-ID: BB8FB7F6-B40D-46A7-92DA-077BDD8D9077@Chaos1.DE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2022-06-23 09:07:01 Re: hot_standby_feedback via intermediate replica
Previous Message James Pang (chaolpan) 2022-06-22 14:15:34 RE: multiple sessions to create index in parallel support