Questions tagged [pg-logical]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ----...