Postgres Pro
Downloads
Home   >   mailing lists

Cascaded Replication question - Mailing list pgsql-admin

From Alexander Pogodin
Subject Cascaded Replication question
Date
Msg-id 1254601719.7524472.1673277867599@mail.yahoo.com
Whole thread Raw
Responses Re: Cascaded Replication question  (Alexander Pogodin <alex_pogodin@yahoo.com>)
List pgsql-admin
Tree view
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.

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: pg_stat_replication_slots view
Next
From: Samed YILDIRIM
Date:
Subject: Re: csv vs json?