Questions tagged [pg-logical]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
24 views

Dump pglogical Config to files

We use the tool etckeeper to keep track of the configuration of servers. I would like to dump the configuration of pglogical to files for this purpose. I tried this: db@host:~$ pg_dump -t '...
0
votes
0answers
5 views

ERROR: table test_snadbox.pgbench_history is already being synchronized

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 ...
0
votes
1answer
25 views

How to resolve the error for “Alter Subscription disable”?

I have the following subscription for logical replication: pctest1=> SELECT subscription_name, status FROM pglogical.show_subscription_status(); subscription_name | status ----...