Questions tagged [pg-logical]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
25 views

Pglogical - multiple database tables to single table

I have 4 databases, each database is having 2 tables. The table structure on all the databases are same. So i want to replicate these two tables from all 4 databases to a single database. So my ...
0
votes
1answer
34 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
8 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
42 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 ----...