Postgres Maintenance

Add or remove replication slots from a PostgreSQL database postgres create replication slot We need to sync the postgresdata directory The PostgreSQL way is to run pg_basebackup which syncs it over the replication slot Here is a postgresql drop replication slot Learn how to use replication slots with PostgreSQL's streaming physical replication We also discuss their benefits and disadvantages

postgres create logical replication slot Now a common cause for this kind of issue are replication slots which are not advanced: in that case, Postgres will hold on to all WAL segments