Postgres 16: Logical decoding on standbys

Postgres 16: Logical decoding on standbys 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 postgres create 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

postgres create replication slot The default is 10 This parameter can only be set at server start Setting it to a lower value than the number of currently existing replication slots will

postgres drop replication slot SELECT * FROM pg_replication_slots to see if any replication slots were accidentally created that might be preventing WAL cleanup · SHOW To ensure that WAL segments are not discarded before being sent to all consumers, PostgreSQL uses logical replication slots to track which data was sent to