Postgres logical replication concepts

website postgresql create replication slot Specify that this replication slot is a temporary one Temporary slots are not saved to disk and are automatically dropped on error or when the session has postgresql replication slot slot=pg2 $ echo $? 0 $ psql -c DROP_REPLICATION_SLOT pg2 host= port=5432 replication=database user=mba dbname=postgres SELECT $ This would get

postgresql create replication slot Optional parameter that when yes specifies that the LSN for this replication slot be reserved immediately, otherwise the default, no , specifies that the  The function pg_create_physical_replication_slot is used to create a physical replication slot This command has to be run in the master node   However, if we only want to replicate a portion of the database tables, then Physical Replication in this case is not ideal To improve the

Share

Share

Link

Turn off sharing Copy link

See all details