Add documentation for enabling logical replication in pipelinewise postgres tap
Problem to solve
Meltano docs do not reference the prerequisites for setting up the prerequisites needed for syncing via logical replication.
The steps needed are only mentioned in the GitHub docs of the Pipelinewise Tap Postgres, and not on their website docs.
- Prerequisites - https://github.com/transferwise/pipelinewise-tap-postgres#log-based-replication-requirements
Also, here is a guide how to enable logical replication on AWS RDS - https://aws.amazon.com/blogs/database/using-logical-replication-to-replicate-managed-amazon-rds-for-postgresql-and-amazon-aurora-to-self-managed-postgresql/
Target audience
Everybody who is using the transferwise (pipelinewise) tap postgres and want to setup logical replication
Further details
Logical Replication is pretty much the best sync method, Meltano docs should cover everything without needing to go to the docs of Pipelinewise
Proposal
Add step by step guide mostly taken from https://github.com/transferwise/pipelinewise-tap-postgres#log-based-replication-requirements and https://aws.amazon.com/blogs/database/using-logical-replication-to-replicate-managed-amazon-rds-for-postgresql-and-amazon-aurora-to-self-managed-postgresql/
What does success look like, and how can we measure that?
Meltano docs have all the steps how to setup Pipelinewise Tap Postgres with logical replication as the sync method