pgreplicate

README

pgreplicate

Re-usable component for subscribing to row-level changes on a postgres database

Development

In order to run tests the postgres database needs to be configured to allow logica replication. This can be enabled by adding the follwowing to the postgresql.conf

wal_level=logical
max_wal_senders=5
max_replication_slots=5

Resources

Various resources were use to develop this component:

• https://github.com/jackc/pglogrepl
• https://github.com/blind-oracle/psql-streamer?ref=golangrepo.com
• https://github.com/kingluo/pgcat
• https://www.postgresql.org/docs/9.5/protocol-replication.html
• https://paquier.xyz/postgresql-2/postgres-10-temporary-slot/
• https://www.reddit.com/r/golang/comments/em1ga0/wallistener_eventdriven_architecture/
• https://github.com/ihippik/wal-listener
• https://www.postgresql.org/docs/10/protocol-logicalrep-message-formats.html
• https://pgdash.io/blog/postgres-replication-gotchas.html
• https://github.community/t/how-do-i-properly-override-a-service-entrypoint/17435/7