Questions tagged [pg-logical]

The tag has no usage guidance.

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

Read Postgres CDC data with Logical Replication via Pgoutput plugin and decode it into textual format

Background: We are running Postgres v13.4 and have enabled logical replication for reading CDC data for a select few tables. We are using the pgoutput plugin and the basic setup is working fine. Query:...
user avatar
0 votes
1 answer
37 views

Upgrading Logical Replica of PostgreSQL

I am trying to upgrade a logical replica from PostgreSQL V10 to V13. We are using pglogical for the logical replication. Though the upgrade process of the replica can be done, however the replication ...
user avatar
1 vote
1 answer
81 views

Installing pglogical: Find postgres include folder, add all include folders to C_INCLUDE_PATH

I am trying to install the pglogical extension in my postgres database, which I installed on my macOS with homebrew. I am following instructions provided on the GCP blog as I am preparing to migrate ...
user avatar
0 votes
0 answers
105 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 | ...
user avatar
2 votes
1 answer
187 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....
user avatar
  • 31
2 votes
1 answer
313 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 ...
user avatar
0 votes
0 answers
335 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 ...
user avatar
  • 125
3 votes
1 answer
466 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... ...
user avatar
  • 135
0 votes
1 answer
188 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 ...
user avatar
0 votes
1 answer
124 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 ...
user avatar
1 vote
0 answers
50 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 ...
user avatar
0 votes
0 answers
226 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 ...
user avatar
0 votes
2 answers
79 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 ...
user avatar
0 votes
0 answers
88 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 ...
user avatar
  • 1
2 votes
1 answer
144 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 ...
user avatar
  • 1,698
0 votes
1 answer
134 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 '...
user avatar
  • 1,331
0 votes
1 answer
231 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 ----...
user avatar
  • 83