Questions tagged [pg-logical]
The pg-logical tag has no usage guidance.
14
questions
0
votes
0answers
15 views
pglogical: list Schema/table part of the replication sets?
Is there a way to list all the Schemas which have been added to the replication_set?
# SELECT * FROM pglogical.replication_set;
set_id | set_nodeid | set_name | replicate_insert | ...
2
votes
1answer
18 views
Why can't I setup replication with pglogical? It says I need a primary key even though I have unique constraints
I'm trying to enable replication with pglogical on a database running Postgres 9.6.22, however I can't add one of my tables even though it has a unique constraint:
db=> SELECT pglogical....
2
votes
1answer
88 views
Postgres major version upgrade using replication server
I am planning to upgrade my database from Postgres 10 to Posgres 14. To reduce the downtime, I plan to use the replication for the same. Plan (in short) is to:
Dump the data using pg_dumpall
Kill the ...
0
votes
0answers
58 views
Postgresql pg_logical sequence replication not synchronized
I'm testing pg_logical extension for Postgresql because we need to replicate some clusters with Postgresql 9.6 before upgrading them to newer version, where logical replication is a core feature.
I've ...
3
votes
1answer
86 views
Postgres difference between restart_lsn and confirmed_flush
According to the documentation, restart_lsn is
The address (LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints...
...
0
votes
1answer
49 views
Show more details on Postgres logical replication errors
Wonder if there is a way to add more details (like the column name, database) to logical replication errors in case of missing columns. I got general log entries like this:
2021-09-16 14:47:37.149 CDT ...
0
votes
1answer
21 views
Limit size of WAL files for PostgreSQL database
I'm using AWS RDS PostgreSQL 13 database in a master-slave configuration using logical replication with pglogical extension.
Recently, one of the application migrations has updated the schema of the ...
1
vote
0answers
23 views
Create logical replication along with normal replication [closed]
I need to replicate only some of the tables from my Master Postgres.
With Google search, I got to know that it is possible with logical replication from Postgres10.
I already have a read-only replica ...
0
votes
0answers
92 views
Unable to replicate Postgres tables using logical replication in RDS
Tables in the destination database are empty even after subscription is successful.
I am extremely new to logical replication within Postgres. I am trying to replicate three tables from the source ...
0
votes
2answers
54 views
Error when passing variable to function
I've created a function in PostgreSQL 11.10 to handle DDL change in pglogical to apply it into subscriber. Here is the function:
CREATE OR REPLACE FUNCTION public.intercept_ddl()
RETURNS ...
0
votes
0answers
49 views
2ndQuadrant/Pglogical multi-master cluster installation
I'm looking for a way to make a multi-master cluster with pglogical.
When I say multi-master, it's means 3 nodes, where each of them is a provider and a subscriber.
Currently I have two nodes that ...
1
vote
1answer
98 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
109 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
169 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
----...
