Postgres Pro
Downloads
Home   >   mailing lists

Starting logical replication at arbitrary point that's available in WAL - Mailing list pgsql-general

From Alexander Uvizhev
Subject Starting logical replication at arbitrary point that's available in WAL
Date
Msg-id facf084c-83e8-46be-bdeb-2c94cb16d66e@posteo.net
Whole thread Raw
Responses RE: Starting logical replication at arbitrary point that's available in WAL
List pgsql-general
Tree view 
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
||

pgsql-general by date:

Previous
From: "Pierre Barre"
Date:
Subject: Re: Preallocation changes in Postgresql 16
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: Starting logical replication at arbitrary point that's available in WAL