Questions tagged [pg-logical]
The pg-logical tag has no usage guidance.
4
questions
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
----...
