0

I have setup logical replication between two servers in PostgreSQL 11. For some table replication is not working. I dropped those table from publication and added them back and refreshed subscription .still replication has not happened. I checked subscriber log ,no error there in the log also. what could be the reason for this . how to troubleshoot this issue.

Improve this question
2
  • Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Commented Nov 12, 2021 at 11:18
  • replica identity ? Commented Jan 12, 2022 at 12:55

1 Answer 1

Reset to default
0

ensure the parameters, Check the replication slot status and pg_subscription_rel status by refer the documentation https://www.postgresql.org/docs/current/catalog-pg-subscription-rel.html. If you could see status=i you have to re-configure the replication by increasing max_logical_replication_workers & max_work_processer.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.