Replication Slot size increasing rapidly for postgresql

website postgresql create replication slot It is important to remove unused replication setups, since the underlying replication slots in PostgreSQL forces the server to keep all the data needed to postgresql create replication slot A simple case of spill is explained below In the logical replication setup of PostgreSQL 14, prepare one table named tab with an integer column

postgresql create replication slot There are two types of replication slots: logical and physical Logical slots have the property to be able to connect to a particular database,  Logical replication slots are used to track the WAL positions on the primary server so that the standby server can request  Resolution · Turn on logical replication · Connect to source database in source DB instance · Create a publication for source tables · Connect to target database

Share

Share

Link

Turn off sharing Copy link

See all details