Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.

Поиск
Список
Период
Сортировка
От vignesh C
Тема Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.
Дата
Msg-id CALDaNm1M_GOyuAZCwFHbc_PcOt0rfVd23pEQ7f86E93im0_UEA@mail.gmail.com
обсуждение исходный текст
Ответ на RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.  ("Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>)
Список pgsql-hackers
On Tue, 18 Feb 2025 at 06:22, Hayato Kuroda (Fujitsu)
<kuroda.hayato@fujitsu.com> wrote:
>
> I'm not sure we must really handle the case. Documentation [1] has already described
> not to run DDL commands during the command:
>
> ```
> Since DDL commands are not replicated by logical replication, avoid executing DDL
> commands that change the database schema while running pg_createsubscriber.
> If the target server has already been converted to logical replica, the DDL commands
> might not be replicated, which might cause an error.
> ```

Yes, that makes sense. Since the same applies to tables created while
pg_createsubscriber is running, and there is already generic
documentation covering this, I agree with you.

Regards,
Vignesh



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