Hi,
I'm doing a logical replication using streaming replication protocol and I'm trying to start a stream from a certain arbitrary point that's available in WAL. However, both CREATE_REPLICATION_SLOT and pg_create_logical_replication_slot() create slot with nearly last LSN/XID.

Is it possible to create a replication slot with arbitrary LSN/XID values?

Also pg_create_logical_replication_slot() for some reason gives different result than CREATE_REPLICATION_SLOT: new slot's `catalog_xmin` is set to the smallest `catalog_xmin` among already existing slots. Looks like a bug.

I'm using PostgreSQL 16.6.

--
AU
||


Reply via email to