python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - logical-replication

postgresql subscription not working for schemas other than public

I'm trying to create a logical replication with two local postgresql servers (node1: port 5434, node2: port 5435). I could successfully create publication and subscription on node1 and node2 for a tab...
test-img

Tony

postgresql

schema

replication

logical-replication

Votes: 0

Answers: 1

Latest Answer

You have to give the user repuser permission to read the table that should be replicated. That also requires USAGE permission on the schema that contains the table.
test-img

Laurenz Albe

Posts

Questions

Blogs

Jobs