Logical replication slots on slaves/replicas?

From: Piotr Andreassen Blasiak <piotr(at)attendium(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Logical replication slots on slaves/replicas?
Date: 2024-08-01 08:42:20
Message-ID: AB145716-132B-4BB5-AC69-32EA9FDE4633@attendium.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I know that currently logical replication slots are available only for primary servers. Is there any plan to add this feature to read slaves as well? My problem is this:

I want to use debezium to stream changes from postgresql. But, if I stream changes from the master I can not query my read slaves for related data to these changes - I need to always query the master which is not scalable. So either I need a way to be able to know when the change has been propagated to my read replica so that I can reliably query it, or I am hoping I can simply read all the changes from the read replica which will mean it is already up to date when I query it.

Piotr Andreassen Blasiak

Responses

Browse pgsql-general by date

  From Date Subject
Next Message shammat 2024-08-01 09:05:09 Re: Logical replication slots on slaves/replicas?
Previous Message semab tariq 2024-08-01 04:05:02 Re: Monitoring DB size