Starting logical replication at arbitrary point that's available in WAL

Поиск
Список
Период
Сортировка
От Alexander Uvizhev
Тема Starting logical replication at arbitrary point that's available in WAL
Дата
Msg-id facf084c-83e8-46be-bdeb-2c94cb16d66e@posteo.net
обсуждение исходный текст
Ответы RE: Starting logical replication at arbitrary point that's available in WAL
Список pgsql-general
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 по дате отправления: