Questions tagged [pg-logical]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
20 views

How can I leverage synchronize_structure in pglogical?

I'm setting up very barebones pglogical setup going from 9.6 → 11. I put together one recipe which worked, where I replicated the schema first myself. Now I'm trying to leverage synchronize_structure ...
1
vote
1answer
35 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
57 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
1answer
77 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 ----...