Loading video...
Video Failed to Load
Introducing PGSync 🐘 Real-time PostgreSQL replication. FREE. OSS Built in Rust. 🦀 Postgres 16 / 17 / 18. No extensions. No triggers. No complex setup. → snapshot → replicate → stream changes → track WAL → recover from crashes → resume automatically → keep databases in sync ~15 MB... show more
135,020 views • 27 days ago •via X (Twitter)
22 Comments
Built in Rust. Fast, lightweight, reliable. 🦀
Zero gaps between snapshot and streaming.
yesss
Next up: data masking + PGX integration. 🚀
Data masking is a game changer.
no triggers is what sold me how does it handle schema changes mid stream
A good question!
Но как это отличается от встроенной в PostgreSQL логической репликации?
PGSync is a standalone Rust engine with automated safety checks, crash recovery, WAL monitoring, and ~15 MB RAM usage.
Will save this for later, looks interesting
Sure, lmk your feedback!
no extensions no triggers is the line that sells it setup is where most replication tools lose people
no setup, just use it
v1.1 cargo install pgsync
Nice, no triggers is a big plus. A feature worth having early: an allow-list of tables and columns to sync, so a copy to analytics doesn't quietly carry password hashes and personal data along with everything else.
100% agree! Table and column allow-lists are on the roadmap, along with PGFake integration for data masking. 🔥
Allow-lists plus masking covers it nicely. That combo is what lets a team say yes to syncing prod data without a long meeting first. Will keep an eye out for the release 🙌🏾
yessss
Lol just have you ai write a script
sure,. open for contribution!
can it sync while the replica is being in use?
Yes! You can read and query the replica while PGSync streams changes in the background.
