Move your data from PostgreSQL Batch with your free account

The PostgreSQL Batch Query connector in Estuary captures data from PostgreSQL databases by periodically executing queries and loading the results into Estuary collections. It is useful when logical replication is unavailable, when capturing from database views or certain read replicas, or when you need custom SQL queries.

• XMIN-based incremental capture for regular PostgreSQL tables using the xmin system column
• Initial full backfill followed by incremental updates when XMIN mode is used
• Cursor-based incremental capture using fields such as timestamps or incrementing IDs
• Full-refresh capture for tables or views without a cursor
• Custom SQL queries for filtering, aggregations, or capturing specific subsets of data
• Configurable polling schedules, with a default interval of 5 minutes
• Optional discovery of PostgreSQL views
• Automatic use of primary keys as Estuary collection keys when available
• Support for self-hosted PostgreSQL and managed platforms, including Amazon RDS and Aurora, Google Cloud SQL, and Azure Database for PostgreSQL

For ordinary tables, discovered bindings use XMIN mode by default. The first poll performs a full backfill, and subsequent polls capture rows with newer transaction IDs. Other bindings can use cursor-based incremental queries, full refreshes, or custom query templates.