Finally got this useful tool:
https://github.com/EnterpriseDB/pg_failover_slots
Since I usually do scheduled switchover, this tool really helps a lot.
On Tue, Apr 11, 2023 at 10:39 AM milist ujang
wrote:
> I have a case that master has been restarted many times, restart_lsn not
> moved since no
I have a case that master has been restarted many times, restart_lsn not
moved since nov 2022 till today apr 2023.
I have tried pg_replication_slot_advance() but no luck :-(
postgres 12.8
1 master (4 publisher) many SR slaves, and 1 logical replication (4
subscribers)
Is there a chance to edit th
When logical replication is setup, any wal generation on any tables will
result in replication lag. Since you are running a long running transaction
on the master, the maximum number of changes kept in the memory per
transaction is 4MB. If the transaction requires more than 4MB the changes
are spil
Hello.
At Tue, 18 Aug 2020 09:27:34 -0700, Satyam Shekhar
wrote in
> Hello,
>
> I wish to use logical replication in Postgres to capture transactions as
> CDC and forward them to a custom sink.
>
> To understand the overhead of logical replication workflow I created a toy
> subscriber using t
Hello,
I wish to use logical replication in Postgres to capture transactions as
CDC and forward them to a custom sink.
To understand the overhead of logical replication workflow I created a toy
subscriber using the V3PGReplicationStream that acknowledges LSNs after
every 16k reads by calling setA
