Re: Logical replication troubleshooting

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

Please go through PostgreSQL documentation first to develop better understanding.


Later you may go through some videos on Youtube or google. There are tons of step by step examples available.  

Regards,
Muhammad Ikram
Bitnine Global

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


--
Muhammad Ikram

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

Предыдущее
От: Kashif Zeeshan
Дата:
Сообщение: Re: Logical replication troubleshooting
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Logical replication troubleshooting