Re: Logical replication troubleshooting

Поиск
Список
Период
Сортировка
От Kashif Zeeshan
Тема Re: Logical replication troubleshooting
Дата
Msg-id CAAPsdhcMe40ME2Fp1jzy6AmfaRkhRMSqpx7j9AEgNcpbHwmfFg@mail.gmail.com
обсуждение исходный текст
Ответ на Logical replication troubleshooting  (Siraj G <tosiraj.g@gmail.com>)
Список pgsql-admin
Hi Siraj

It all depends on your requirements, you can use as many publication as you want as per your requirements.

Regards
Kashif Zeeshan

On Mon, Jun 24, 2024 at 7:50 AM Siraj G <tosiraj.g@gmail.com> wrote:
Hello Team!

We are trying to migrate a on-premise PgSQL (v10) to GCP Cloud SQL's PgSQL (v10) via PubSub replication. I am trying to get familiar with best practices in this context. We built 2 publications - one for all tables with Primary Keys and other for non-Primary Keys. There are few archive tables with non-primary key are having issues in the replication. How do we troubleshoot this? Is it a best practice to bifurcate publications this way?

Regards
Siraj

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

Предыдущее
От: Siraj G
Дата:
Сообщение: Logical replication troubleshooting
Следующее
От: Muhammad Ikram
Дата:
Сообщение: Re: Logical replication troubleshooting