Re: Logical replication and truncate table

Поиск
Список
Период
Сортировка
От Jerry Sievers
Тема Re: Logical replication and truncate table
Дата
Msg-id 87v9cslaiv.fsf@jsievers.enova.com
обсуждение исходный текст
Ответ на Logical replication and truncate table  (Yambu <hyambu@gmail.com>)
Ответы Re: Logical replication and truncate table
Список pgsql-admin
Yambu <hyambu@gmail.com> writes:

> Hello
>
> Please confirm this , truncate a table on master db does not work
> well wilth logical replication?
> It results in duplicate key errors on slave right?

Trunc has been supported in native logical replication since V11.

Start by telling us what Pg version you're on and what logical
replication your using.

See the docs.
>
> We should rather use delete from table?
>
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net



В списке pgsql-admin по дате отправления:

Предыдущее
От: Yambu
Дата:
Сообщение: Logical replication and truncate table
Следующее
От: Yambu
Дата:
Сообщение: Re: Logical replication and truncate table