Features

Key features of PGSync include:

• Works with any PostgreSQL database (version 9.6 or later).
• Negligible impact on database performance.
• Transactionally consistent output in Elasticsearch/OpenSearch. This means: writes appear only when they are committed to the database, insert, update and delete operations appear in the same order as they were committed (as opposed to eventual consistency).
• Fault-tolerant: does not lose data, even if processes crash or a network interruption occurs, etc. The process can be recovered from the last checkpoint.
• Returns the data directly as Postgres JSON from the database for speed.
• Supports composite primary and foreign keys.
• Supports an arbitrary depth of nested entities i.e Tables having long chain of relationship dependencies.
• Supports Postgres JSON data fields. This means: we can extract JSON fields in a database table as a separate field in the resulting document.
• Customizable document structure.