Skip to main content

Questions tagged [pg-logical]

pglogical is a PostgreSQL extension that implements a publish-subscribe replication model. Use this tag specifically when asking questions about that extension; do not use it for questions about the PostgreSQL native logical replication, available since version 10. Include also the generic "postgresql" tag, along with the version-specific Postgres tag.

Filter by
Sorted by
Tagged with
0 votes
1 answer
72 views

Logical replication delay in postgres16(Bidirectional)

We have noticed logical replication delay at times(even non peak hours also) in postgres16 bidirectional replication. Even though we configured bi directional, traffic is from prod1 to prod2 only. ...
RK DBArchitect's user avatar
1 vote
0 answers
66 views

PostgreSQL replication role without permission to see or delete other replication slots

We have a PostgreSQL server with multiple databases for different projects. We want to use logical replication on those databases so the applications receive all the changes for their replication slot ...
Eleasar's user avatar
  • 111
0 votes
0 answers
24 views

Benefits of using pglogical 2.4.1 over Postgres 12 build-in logical replication?

I'm migrating a Postgres version 12.14 database. I've tested the migration twice: once using the pglogical extension 2.4.1 and once using Postgres' built-in logical replication. It seems like ...
trouble_bucket's user avatar
0 votes
1 answer
163 views

Using logical replication to migrate a large Aurora database from AWS to on-premises PostgreSQL

After 5 years and many $$$ spent on keeping our data in an AWS RDS Aurora PostgreSQL cluster, we now want to bring the 12 TB of data back to an on-premises PostgreSQL instance, specifically a Crunchy ...
Robert's user avatar
  • 13
0 votes
1 answer
278 views

Postgresql 12 logical replication catchup state (terminating walsender process due to replication timeout)

I have an issue with our logical replication which is still on catchup state. It would read several lsn then got stuck on a particular lsn (EA/738D4DA8 both on sent_lsn and write_lsn) then reset again....
starting dba jr's user avatar
0 votes
0 answers
254 views

Regarding catalog_xmin in Replication slot

Definition of catalog_xmin from postgres Documentation:- The oldest transaction affecting the system catalogs that this slot needs the database to retain. VACUUM cannot remove catalog tuples deleted ...
manjunath's user avatar
0 votes
1 answer
652 views

Pglogical Replication Status Down

I am using pglogical for logical replication in PostgreSQL cloudsql and I found my subscription down thus data is not replicating at all from source table to target table.. I checked logs on Publisher ...
SRJ's user avatar
  • 101
0 votes
1 answer
197 views

Regarding Hot_standby_feedback parameter

I have seen in source code (https://github.com/postgres/postgres/blob/914e72e6e8d3e94346f3495dac36d46aa9912bb5/src/backend/replication/walreceiver.c#L1191) regarding XLogWalRcvSendHSFeedback function ...
manjunath's user avatar
0 votes
1 answer
903 views

what is pg_replication_slot_advance() function in logical replication and how the values restart_lsn and confirmed_flush_lsn change after advancing?

information provided about the function in PostgreSQL documentation. pg_replication_slot_advance ( slot_name name, upto_lsn pg_lsn ) → record ( slot_name name, end_lsn pg_lsn ) Advances the current ...
manjunath's user avatar
1 vote
1 answer
984 views

Why does postgresql have so many replication slots open?

I use logical replication to move changes from my primary to a replica. Today, to update the replica, I: disabled the subscription on the replica (ALTER SUBSCRIPTION foo DISABLE;) upgraded it to ...
mlissner's user avatar
  • 593
2 votes
1 answer
903 views

Postgres Logical replication data missing in Slave - Out of sync

The issue started with the replication lag between Master and slave (Logical Replication Server) upto 30 GB lag and the lag wasn't coming down for a proper sync and was in catchup state. The ...
Sandesh Bailur's user avatar
0 votes
1 answer
79 views

Question about PostgreSQL Logical replication behaviour

Generally when a transaction commits in PostgreSQL, then immediately the logical decoding process will start and convert the WAL data into steam of data for consumers. My understanding is Commit » WAL ...
TheDataGuy's user avatar
  • 1,950
4 votes
1 answer
2k views

Postgres SQL Logical Replication Out of Sync - How to Resume Subscription

I'm worried that unfortunately there's not a great way to handle this. Here's what happened: Schema change made in main database Logically replicated db has issue with subscription given the identity ...
jlarks32's user avatar
  • 141
1 vote
0 answers
988 views

PostgreSQL Logical Replication Lag

I am using pglogical extension for logical replication between a PostgreSQL version 10 and 13. I have multiple databases in the primary which are replicating data to three databases in logical replica....
Sayad Xiarkakh's user avatar
0 votes
2 answers
2k views

Sync Schema changes automatically with Logical Replication Postgresql

I know there is limitation for logical replication to publish schema change to the subscriber. And for example if you add a column in publisher you have to manually add the same column to the ...
jimpster's user avatar
0 votes
0 answers
6k views

How to activate replication slot

I have 2 logical replication slots in Postgres 12. Suddenly one of them (100 fields, 16K records) failed couple of days ago. Obviously, the replication slot is inactive. Then I check a couple of ...
padjee's user avatar
  • 197
0 votes
1 answer
449 views

slave on logical replication does not get update real time

I successfully started logical replication on a testing environment. I generate insert on the master for some 60K records using procedure. While the insert process is running, i monitor the slave ...
padjee's user avatar
  • 197
-2 votes
1 answer
430 views

Can min_wal_size bigger than max_wal_size?

is it possible if min_wal_size bigger than max_wal_size ? What happen if it does ? What are the circumstances when min_wal is bigger than max_wal ? I am using PG 12. Thanks
padjee's user avatar
  • 197
1 vote
1 answer
2k 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:...
Devendra's user avatar
0 votes
1 answer
345 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 ...
Sayad Xiarkakh's user avatar
1 vote
1 answer
1k 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 ...
Dinosaur Reporter's user avatar
0 votes
1 answer
850 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 | ...
Gowthamakanthan Gopal's user avatar
2 votes
1 answer
2k 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....
afclear's user avatar
  • 31
3 votes
1 answer
2k 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 ...
user1583803's user avatar
2 votes
0 answers
1k 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 ...
EAmez's user avatar
  • 155
3 votes
2 answers
2k 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... ...
sha's user avatar
  • 137
0 votes
1 answer
973 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 ...
Javier Galarza's user avatar
0 votes
1 answer
895 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 ...
Slava Fomin II's user avatar
1 vote
0 answers
196 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 ...
AATHITH RAJENDRAN's user avatar
0 votes
0 answers
636 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 ...
sparsha dotel's user avatar
0 votes
2 answers
181 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 ...
Hendra Budiawan's user avatar
0 votes
1 answer
477 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 ...
celtia's user avatar
  • 1
2 votes
1 answer
310 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 ...
TheDataGuy's user avatar
  • 1,950
0 votes
1 answer
250 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 '...
guettli's user avatar
  • 1,531
1 vote
1 answer
678 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 ----...
pricha's user avatar
  • 143