Implementing failover of logical replication slots in Patroni

Allow you to replicate data out of Postgres · Use the write-ahead log as the source of changes · Use logical replication slots to send out

Resolution · Turn on logical replication · Connect to source database in source DB instance · Create a publication for source tables · Connect to target database

postgres replication slot The logical replication stream is mostly a binary protocol But the actual column values are transmitted as text This means that when Postgres

postgres create replication slot In a logical replication scheme, high-level write operations are streamed from a master database server into one or more replica database