Skip to main content
Database Administrators

Questions tagged [pg-logical]

Ask Question

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.

38 questions
Newest Active Bountied Unanswered
1 vote
0 answers
69 views

We recently encountered an issue in our production environment involving logical replication on our AWS RDS PostgreSQL 16.3 instances. Our current setup allows developers to add tables to replication ...
John G's user avatar
  • 11
0 votes
0 answers
326 views

I am trying to assess pglogical replication usage instead of the built-in one (particularly due to being able to filter by operation). I am using a single Azure Postgresql flexible server database ...
Alexei's user avatar
  • 1,193
0 votes
1 answer
288 views

I've got two Postgres 13 databases on AWS RDS. One is a master, the other a slave using logical replication. Replication has fallen behind by about 350Gb. The slave was maxed out in terms of CPU for ...
mj_'s user avatar
  • 349
0 votes
1 answer
62 views

My database cluster currently uses logical replication with wal_level set to logical. How can I integrate Point-In-Time Recovery (PITR) into this setup without changing the wal_level? If it's possible,...
Danish Ahamed's user avatar
  • 3
0 votes
1 answer
448 views

I would like to allow an application's database to execute DELETE statements. However, for analytics purposes, I would like to keep all data, even deleted data. I'm trying to figure out if there is a ...
Chad M's user avatar
  • 143
0 votes
1 answer
314 views

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
1 vote
0 answers
149 views

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
1 answer
572 views

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
  • 125
0 votes
1 answer
675 views

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
  • 85
0 votes
1 answer
1k views

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
351 views

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
  • 137
0 votes
1 answer
2k views

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
  • 137
1 vote
1 answer
2k views

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
  • 673
2 votes
1 answer
1k views

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
  • 23
0 votes
1 answer
118 views

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,992

15 30 50 per page
1
2 3