Cascaded Replication question

From: Alexander Pogodin <alex_pogodin(at)yahoo(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Cascaded Replication question
Date: 2023-01-09 15:24:27
Message-ID: 1254601719.7524472.1673277867599@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello, guys!
I have a setup with 3 PgSQL instances connected with streaming replication as such:

+---+     +---+     +---+
| A | <-- | B | <-- | C |
+---+     +---+     +---+

When the link to A is broken, I manually promote server B and expect server C to follow new timeline: I have recovery_target_timeline set to latest. But that's not the case. To follow new timeline I have to restart server C. Is it the designed behavior or am I missing something?
I am using the latest 10.x version.

Could you, please, advise?

Best regards, Alex Pogodin.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Samed YILDIRIM 2023-01-09 22:55:47 Re: csv vs json?
Previous Message Ron 2023-01-08 18:21:45 Re: pg_stat_replication_slots view