Replication slot in PostgreSQL

With the change in Postgres 16, when you're on a standby, you can actually create a logical replication slot There are a few mechanics around

Let's say for instance you have a replication user called replication , created WITH REPLICATION , the role doesn't actually have permissions to

postgresql create replication slot The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state For more

postgres create logical replication slot Replication slots were introduced with PostgreSQL and are designed to ensure that any standby connected to the primary using a replication slot will always