Logical replication is a feature of PostgreSQL 10. It is a method of replicating data objects and their changes, based upon their replication identity (usually a primary key)
Questions tagged [logical-replication]
113 questions
0
votes
2 answers
Why is my logical replication failing with "could not drop replication slot ... does not exist"?
Our logical replication has started to fail with a lot of these errors on the subscriber:
ERROR: could not create replication slot
"pg_148211637_sync_148178452_7161337762731575223": ERROR: all replication slots are in use
May 2 07:43:01 psql-06…
Niels Kristian
- 8,661
- 11
- 59
- 117
0
votes
1 answer
Postgres logical replication subsynccommit off
I've got postgres 13 version and I've tuned logical replication from another
server.
I started replication, my tables are full of data. But when I add data on
publisher it is not added on replica. Logs are empty.
I've queryed
report=# select * from…
Gerzzog
- 95
- 7
0
votes
0 answers
Postgres: Physical and logical replication on one server
We are planning to get Postgres 13 version server.
We want to have one master server, which will get data
from various servers using logical replication. On this server,
using procedure we'll transform data.
Additional to this
we plan to have slave…
Gerzzog
- 95
- 7
0
votes
0 answers
patroni - permanent logical replication slots - not working
I am trying to implement logical replication in a postgres cluster, where cluster switchover/failover is managed by patroni. I am trying to leverage the permanent replication slot feature. Using patroni version 2.1.1 on Postgres version 13.5.
I have…
EXK
- 23
- 4
0
votes
0 answers
Connection issues between Slave and Master when setting up Logical Replication in Aurora MySQL (Error Code: 2003)
I am following the guide here to set up Logical Replication in Aurora MySQL[1]: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Replication.MySQL.html
After setting it up and starting the replication process, I run "show…
selfname
- 51
- 5
0
votes
0 answers
PostgreSQL Logical Replication not working at all
For reference, I'm using PostgreSQL 14.3 with PGAdmin. I have 2 databases within the same cluster of databases (or server group if cluster isn't the right word).
So, I have 2 dummy DBs for the purposes of testing this (game and game sub, as…
Skullruss
- 63
- 8
0
votes
2 answers
Logical replication for separate schema within the SAME database in Postgresql
For reference, I'm using PostgreSQL version 14.3
Let's say I have two schema, X and Y, and in X I have a table called customer, which will be touched by a customer microservice. I want Y to be able to see the data that is added/changed/removed in…
Skullruss
- 63
- 8
0
votes
0 answers
pglogical logical plugin missing DML records
Created pglogical plugin replication slot.
SELECT 'init' FROM pg_create_logical_replication_slot('demo_slot', 'pglogical_output');
Created table which have primary key.
create table pglogical_test(id serial primary key,name text);
Inserted few…
Bandi LokeshReddy
- 115
- 1
- 1
- 12
0
votes
1 answer
Postgresql - Logical Replication maintenance
In our organization, we are running Postgres 14.5. There is requirement from our team to enable logical replication for few tables. Current WAL_Level is "Replica".
Now, I need change this to "logical" to enable logical replication. My doubt is, if…
Senthil
- 27
- 6
0
votes
1 answer
we are not able to replicate 5GB table in postgresql using logical replication
we have multiple tables and all are replicated successfully except one table which is in size of 5GB. Once we created replication slot, the size of the server is growing high but can't see the data. we are using Postgres 12 and Logical…
0
votes
0 answers
Avoid 'interleaved LSN' in postgres replication slot
I am trying to stream data from postgres replication slot with output plugin 'test_decoding'. When there are big, multiple transactions running, the output plugin seems to have interleaved LSN, ie, they are not in sequence.
How can I have the…
Adrij Shikhar
- 13
- 4
0
votes
0 answers
Queries on implementing postgres logical replication for production?
Will there be any situation where the replication gets failed? If so
how to manage that failover?
Is there any queries to identify the no.of pending records to be replicated?
How to manage failover/DR like situation?
Can we do…
M.S.Udhaya Raj
- 150
- 1
- 12
0
votes
0 answers
Logical Replication Structure Change History Sync
Lately I am using PostgreSQL for replicating some data from multiple databases to a single database. For testing the Logical Replication I have created a simple example transferring data from one database to another only for a single table. The idea…
Stavros Koureas
- 1,126
- 12
- 34
0
votes
0 answers
PostgreSQL Logical Replication Skip LSN of previous iteration
Lately I am using PostgreSQL for replicating some data from multiple databases to a single database. For testing the Logical Replication I have created a simple example transferring data from one database to another only for a single table. The idea…
Stavros Koureas
- 1,126
- 12
- 34
0
votes
1 answer
Postgresql logical replication Docker container
I'am actually working on the logical replication between my master on Windows and slave on Linux.
I want to transfer all my datas to my slave with logical replication Postgresql.
My postgres on Linuw will be working as docker container.
During the…
Makina74
- 45
- 6