pgsync 2.5.0


Postgres to Elasticsearch/OpenSearch sync

Postgres to Elasticsearch/OpenSearch sync

Stars: 908, Watchers: 908, Forks: 147, Open Issues: 143

The toluaina/pgsync repo was created 4 years ago and the last code push was 2 weeks ago.
The project is popular with 908 github stars!

How to Install pgsync

You can install pgsync using pip

pip install pgsync

or add it to a project with poetry

poetry add pgsync

Package Details

Tolu Aina
GitHub Repo:


No  pgsync  pypi packages just yet.


A list of common pgsync errors.

Code Examples

Here are some pgsync code examples and snippets.

GitHub Issues

The pgsync package has 143 open issues on GitHub

  • pgsync on daemon mode dont insert into opensearch
  • Bootstrap fails when objects have upper case characters in their names.
  • Redis bulk issue
  • Can i install this package into astra linux?
  • getting 429 while sending bulk request
  • fix: issue 418
  • memory leak on long sync
  • Support AWS OpenSearch Serverless
  • AttributeError: 'str' object has no attribute 'items'
  • Fixes #463: Through tables for grandchildren with relationships
  • Allow multiple tables per index
  • through_tables does not work on grandchildren
  • Front end not working at port 8000
  • Support concat for children node fields
  • How do I run the bootstrap and pgsync command line with multiple schema.json files?

See more issues on GitHub

Related Packages & Articles

mage-ai 0.9.10

Mage is a tool for building and deploying data pipelines.

hathi 1.7.0

A SQL host scanner and dictionary attack tool. Comes with a script ( to filter a series of password lists based on password strength.

archivy 1.7.7

Minimalist knowledge base focused on digital preservation and building your second brain.

sqlglot 17.9.1

sqlglot is a Python package that serves as a comprehensive SQL parser, transpiler, optimizer, and engine. It is designed to read a wide variety of SQL inputs and output syntactically and semantically correct SQL in the targeted dialects. The package can be used to format SQL or translate between 19 different dialects like DuckDB, Presto, Spark, Snowflake, and BigQuery. It falls under the category of Database Management Systems (DBMS).