Debug PostgreSQL logical apply process

Поиск
Список
Период
Сортировка
От Ramnivas Chaurasia
Тема Debug PostgreSQL logical apply process
Дата
Msg-id CAGwus2WdVtT7DqQr_CsWtvENEvm5VJjXwOzjC=_o97-1CECbpA@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Hello,
We have configured "pglogical" in AWS Aurora. But the "subscription" process keeps going down frequently. We don't get enough log in database error log to know exactly what's causing the problem (we have tried setting the "log_min_messages" and "pglogical.conflict_log_level" upto "debug5") . From the replication slot, we can get the SQL statement where apply process breaks, but running that statement manually on the target side works just fine. Replication process is configured with "postgres" (admin user). Is there a way we can force the "apply" process to spill more info in the error log file? Or some other way to troubleshoot?

PostgreSQL Version: 12.6
Pglogical Version: 2.3.2

Thanks in advance!
Ramniwas

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL 14: pg_dump / pg_restore error: could not write to the communication channel: Broken pipe
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Force re-compression with lz4