PgLogical ERROR: table is already being synchronized

Поиск
Список
Период
Сортировка
От Priancka Chatz
Тема PgLogical ERROR: table is already being synchronized
Дата
Msg-id CANnOdgahppMGNddreQx+fuhAa4X3dYkOMRCo1td+iDD63sVQ8A@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Hi All,
I have configured Logical replication between two Postgres Databases using pglogical.

I have a table that does not have a primary key on the target database. So I first delete all rows and then run the below command:

select pglogical.alter_subscription_resynchronize_table('sandbox_uat_rds_pg10_subscriber','pgbench_history');

It works. However, I missed adding the primary key so I repeat the above: delete from the table and try to resync but running into the below error:

=> select pglogical.alter_subscription_resynchronize_table('sandbox_uat_rds_pg10_subscriber','pgbench_history');
ERROR:  table test.pgbench_history is already being synchronized

However, the number of rows for the table has been 0.

I have tried disabling and then enabling the replication, rerun the resync command multiple times, checked the logs but could not get rid of it.

Any suggestions or solutions?

Regards,

Priyanka

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

Предыдущее
От: Joseph Hammerman
Дата:
Сообщение: Re: SQL workflow for crash testing correctness
Следующее
От: Ekaterina Amez
Дата:
Сообщение: Pg_upgrade error could not load library from 7.14/8.4 to 10.10version