Skip to content

PGSync

PGSync

Coverage Package version Python versions

PGSync keeps PostgreSQL as your source of truth and publishes denormalized documents to Elasticsearch/OpenSearch—continuously and transactionally.

Get started GitHub PyPI Docker

What is PGSync?

PGSync is a lightweight middleware that captures changes from PostgreSQL and writes structured documents to your search cluster. Describe your document schema once (in JSON) and PGSync takes care of change capture, ordering, and delivery—no custom ETL code.

  • Transactionally consistent output (only committed writes; commit order preserved)
  • Low overhead on PostgreSQL
  • Flexible mapping from relational data to nested documents