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
1 answer
How do I synchronize the subscription when the server terminated unexpectedly
I have a publisher and a subscriber. Every so often I get:
ERROR: could not receive data from WAL stream: server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request.
I can…
Henrietta Martingale
- 771
- 8
- 27
0
votes
1 answer
PSQLException: ERROR: column "attidentity" does not exist
I'm using PostgresSQL 9.6 and have a process that is introspecting the database. I have the following error:
org.postgresql.util.PSQLException: ERROR: column "attidentity" does not exist
Position: 169
at…
Christian68
- 845
- 4
- 13
- 24
0
votes
0 answers
Logical decoding on a standby node - any progress?
I read this question:
Logical decoding on a standby node and checked PostgreSQL documentation and PG mail lists but I did not find any up to date info about possibility to use hot standby replica as master for logical replication to other databases.…
JosMac
- 2,164
- 1
- 17
- 23
0
votes
1 answer
postgresql: does logical replication include rollback transaction?
Does the logical replication parse the WAL files in transaction unit? What about the rollback transaction?
And, what's API to ingress data changes at the receiver side, without replaying them in SQL level? Just like the built-in streaming…
kingluo
- 1,679
- 1
- 13
- 31
0
votes
1 answer
How to jump start logical replication in a speedy way?
I'm preparing a migration from PG9.2 to 10.4. The database is large and uses streaming replication. The plan is to switch to logical replication. pg_upgrade works like a charm in a very reasonable amount of time on the master but, as there are over…
O. Gautherot
- 76
- 7
-1
votes
1 answer
Postgresql logical replication between two machine dont't work
I have two machines with postgresql v15 and a config like this :
https://www.youtube.com/watch?v=p1Y2XCskOhY&ab_channel=EDB
I have set wal_level to logical but de replication not work, i create a pub in Machine 1 and de sub in the 2 machine with…
Hamza Assemlal
- 11
- 2
-1
votes
2 answers
Cannot create a conditional publication based on a user-defined type on PostgreSQL 15
I am trying to publicate the cnt_title table using PostgreSQL Logical Replication. Note that I only want to share the product titles.
create publication cnt_publication_for_stk for table
cnt_title where (doc_type = 'PRODUCT');
What I have found is…
coterobarros
- 941
- 1
- 16
- 25
-1
votes
1 answer
Cannot enlarge string buffer containing 1073741779 bytes by 596 more bytes while reading from PGReplicationStream in java
I am running into the following problem.
I want read WAL in postgres database using logical replication and wal2json plugin, Could you please help me how to resolve this issue?
Also I observed that the replication slots after some time became…
lion_pankaj
- 160
- 1
- 12