--- title: "PostgreSQL connector: two-way sync | Stacksync" description: "PostgreSQL connector: Generated keys, replication permissions, and hosting configuration determine the table setup. Setup and validation." canonical: https://www.stacksync.com/connectors/postgresql last_modified: 2026-09-15 --- Database · Two-way sync platform # PostgreSQL connector for two-way sync. Keep PostgreSQL and your business systems aligned with Stacksync. Sync Tables within the connector’s object and field requirements, with two-way sync for eligible records. - Configure field mappings and sync direction - Inspect and resolve record errors in one dashboard [Setup guide: how Stacksync connects to PostgreSQL](https://docs.stacksync.com/two-way-sync/connectors/postgres) Two-way sync for supported objects ## What you can connect Read and write eligible PostgreSQL records. Choose the objects and fields each system owns. - **Tables** Available within the setup requirements **How changes move** The Postgres connector uses logical replication. The separate Postgres Heroku connector uses database triggers when replication rights are unavailable. [Read the connector documentation](https://docs.stacksync.com/two-way-sync/connectors/postgres) ## Adopted by fast-scaling companies moving mission-critical data in real time - Gladia Case study - IDEXX - MedPro Migrated from MuleSoft - Eko Case study - Ubicloud - Vimeo - Codility Migrated from Celigo - ACERTUS Migrated from Heroku Connect - Syringa Migrated from Matillion - Truora - Streaam Case study - SEAL SQ - Rinsed Migrated from Fivetran - IA Capital Group Case study - Meter - Golden Pear Funding Migrated from Celigo Record types ## PostgreSQL objects and coverage. Start with the records your workflow needs. Object-specific permissions and operation limits are shown alongside the available coverage. Tables Check object and field eligibility in the setup guide. [Read the PostgreSQL object and setup guide](https://docs.stacksync.com/two-way-sync/connectors/postgres) Connection setup ## PostgreSQL connection requirements. Check the account access and change-detection requirements for your environment. Your system administrator can help confirm permissions before the first sync. Connection method SQL wire protocol (PostgreSQL frontend/backend protocol) Account access Database credentials (connection string or parameters), with optional SSL root certificate upload and optional SSH tunnel (SSH user + host); a least-privilege DB user How changes are detected The Postgres connector uses logical replication. The separate Postgres Heroku connector uses database triggers when replication rights are unavailable. ### Sync directions - Read data Documented - Write data Documented [PostgreSQLStacksync setup guide](https://docs.stacksync.com/two-way-sync/connectors/postgres) #### Setup prerequisites for your administrator - Use a single-column primary key with a database-generated default for every selected table; composite primary keys are not supported. - Give the connected database role the required ownership and replication rights. Logical replication requires wallevel=logical; check the hosted database procedure before changing it. - For PostgreSQL 12 and earlier, have the database administrator install the pgcrypto extension before starting the sync so tracking tables can use genrandomuuid(). PostgreSQL 13 and later provide this function without the extension. Documentation checked September 15, 2026. #### Setup guides and technical references - [Amazon Lightsail](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/amazon-lightsail) - [Amazon RDS](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/amazon-rds) - [Authorize Postgres](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres) - [Basedash](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/basedash) - [Cloud SQL](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/cloud-sql) - [Digital Ocean](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/digital-ocean) - [Ensuring Secure Cloud SQL Connections with SSL Certificate](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/cloud-sql/ensuring-secure-cloud-sql-connections-with-ssl-certificate) - [Ensuring Secure RDS Connections with SSL Certificate](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/amazon-rds/ensuring-secure-rds-connections-with-ssl-certificate) - [Heroku](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/heroku) - [Postgres](https://docs.stacksync.com/two-way-sync/connectors/postgres) - [Render](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/render) - [Required Permissions](https://docs.stacksync.com/two-way-sync/connectors/postgres/required-permissions) - [Retool](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/retool) - [Snippets](https://docs.stacksync.com/two-way-sync/connectors/postgres/snippets) - [Supabase](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/supabase) Integration design ## Match records and fields for your PostgreSQL integration. Define the row/document key, external application identity, required types, and relationship model. Decide how nested values, nulls, schema changes, and deleted parents appear in the other system. Use your account’s actual field names when applying these matching and dependency checks. ### Explore record matching and field-mapping checks PostgreSQL **Source record ID** Keep the account and record type Record matching **Source ID ↔ destination ID** Link the same record across systems Selected destination **Destination record ID** Preserve its local key and rules *Conceptual identity model. Keep source and destination IDs linked so an update reaches the right record. Confirm the supported sync direction separately.* Match the same record in both systems Keep the database-generated local primary key separate from the external application record ID. Add a unique matching rule for the external ID, and test repeated delivery without creating a second business record. Load related records in the right order Load referenced rows before dependent foreign keys. Confirm the hosting-specific logical replication setup and track schema/table/column changes in the sync configuration. ### Mapping checks by record type #### Tables Check the object requirements below Identity Define a stable key for each table row or document and retain the external application key separately. Confirm the selected connector’s exact key requirements before altering a schema. Fields to consider Local record key · External application ID · Required business fields · Parent record references Related records to resolve first Load referenced rows before dependent foreign keys. Confirm the hosting-specific logical replication setup and track schema/table/column changes in the sync configuration. Test before going live Test repeated delivery, a changed external value, a missing parent, an incompatible type, and a schema change using a representative record. [Download the field-mapping workbook (CSV)](https://www.stacksync.com/downloads/sync-planning/field-mapping-workbook.csv) to capture the actual API fields, matching keys, owners, and test results. Use it as you build with your team or a Stacksync engineer. Setup and validation ## Validate the PostgreSQL integration in four steps. Repeated delivery reaches one intended record; related data remains addressable and incompatible values produce an observable failure. ### View the four setup tests and expected results 1. ### Verify PostgreSQL connectivity and database privileges Use the documented setup from the integration network to the intended host, database, and schema. Have the administrator demonstrate the permissions required for both the first read and later change capture. **Expected result:** The approved role can access the selected data and capture later changes without depending on an administrator’s personal session. 2. ### Verify generated keys and incremental capture Insert and update a test row using the approved database role. Confirm wallevel=logical and required replication rights; PostgreSQL 12 and earlier also need pgcrypto for the tracking-table UUID function. **Expected result:** The local key is generated, the external application identity remains distinct, and the later change is captured through the configured method. 3. ### Test writes in the directions you need Select one eligible PostgreSQL object and writable field. Test the required create/update direction, an invalid value, and a repeated delivery. Check object-specific restrictions before enabling the return path. **Expected result:** The selected operation is confirmed, addresses the intended record, and exposes rejected values for repair. 4. ### Test recovery and name the support owner Interrupt a non-production transfer, restore the connection, and reconcile the selected PostgreSQL records. When using Stacksync’s Retry to sync action, check the latest source value: the retry re-reads current source state rather than replaying an immutable historical event. **Expected result:** The records have the expected current values, repeated delivery creates no duplicate business record, and your team knows who handles unresolved errors. [Use the production-readiness checklist](https://www.stacksync.com/blog/two-way-sync-production-readiness-checklist) to record test results, assign support owners, and agree on when to go live. Troubleshooting ## Troubleshoot your PostgreSQL integration. ### Diagnose record matching, delayed changes, and rejected operations The table loads but later writes are missing Verify logical replication and role permissions for this host. The separate Postgres Heroku connector uses triggers when replication rights are unavailable; confirm which connector is configured. The first load looks correct but later results differ The Postgres connector uses logical replication. The separate Postgres Heroku connector uses database triggers when replication rights are unavailable. Measure the original source change, its capture, and the destination observation separately. Confirm whether the affected object is incremental, historical-only, or subject to a special refresh cycle. One operation succeeds while another is rejected Check the specific PostgreSQL object, field permissions, required references, and allowed operation. A successful read does not establish that a create, update, deletion, or business action is available. [Review retry, replay, and recovery behavior](https://www.stacksync.com/blog/two-way-sync-error-handling-retries-replay) before repeating an operation that may already have succeeded. [Review your PostgreSQL workflow with an engineer](https://www.stacksync.com/book-a-demo?connector=postgresql) ## PostgreSQL integration guides - [checklist Two-Way Sync Production-Readiness Checklist](https://www.stacksync.com/blog/two-way-sync-production-readiness-checklist) - [guide Two-Way Sync Field Mapping Workbook](https://www.stacksync.com/blog/two-way-sync-field-mapping-workbook) - [deep dive The AI Agent Data Layer: Per-App MCP Servers vs a Synced Postgres Database](https://www.stacksync.com/blog/ai-agent-data-layer-mcp-vs-synced-database) - [deep dive Acumatica–Postgres Sync for Beverage Operations: Match Case and Pallet Records Across Warehouses](https://www.stacksync.com/blog/acumatica-postgres-sync-for-beverage-operations-match-case-and-pallet-records-across-warehouses) FAQ ## PostgreSQL connector FAQ ### How should I plan an integration with PostgreSQL? Generated keys, replication permissions, and hosting configuration determine the table setup. Stacksync supports two-way sync for eligible objects. Start with one workflow, agree on which fields each system owns, then test initial data, later changes, and recovery before expanding. ### Can the PostgreSQL connector write changes back? Stacksync supports reads and writes for eligible PostgreSQL objects. Check the selected fields, account permissions, and the other system’s connector. Insert and update a test row using the approved database role. Confirm wallevel=logical and required replication rights; PostgreSQL 12 and earlier also need pgcrypto for the tracking-table UUID function. ### Which identifiers should I preserve for PostgreSQL data? Keep the database-generated local primary key separate from the external application record ID. Add a unique matching rule for the external ID, and test repeated delivery without creating a second business record. ### Which related records should I load first for PostgreSQL? Load referenced rows before dependent foreign keys. Confirm the hosting-specific logical replication setup and track schema/table/column changes in the sync configuration. ### What should I check if PostgreSQL data is missing or delayed? Verify logical replication and role permissions for this host. The separate Postgres Heroku connector uses triggers when replication rights are unavailable; confirm which connector is configured. ### What will we cover in a PostgreSQL integration demo? Start with one workflow and a sample record from Tables. We can review how to identify the record, connect related data, set the update direction, and test recovery. Include the person who owns the source system and anyone who will maintain the integration; you do not need a finished requirements document. ## Explore PostgreSQL connections Choose the other system in your workflow. Each guide explains the connection options, available operations, field mapping, and setup checks for that pair. ### Start with these integration guides - [PostgreSQL and Salesforce](https://www.stacksync.com/integrations/postgresql-and-salesforce) - [Airtable and PostgreSQL](https://www.stacksync.com/integrations/airtable-and-postgresql) - [Amazon DynamoDB and PostgreSQL](https://www.stacksync.com/integrations/dynamo-db-and-postgresql) - [Google Sheets and PostgreSQL](https://www.stacksync.com/integrations/google-sheets-and-postgresql) - [BigQuery and PostgreSQL](https://www.stacksync.com/integrations/bigquery-and-postgresql) - [Datadog and PostgreSQL](https://www.stacksync.com/integrations/datadog-and-postgresql) - [PostgreSQL and Tableau](https://www.stacksync.com/integrations/postgresql-and-tableau) - [Elasticsearch and PostgreSQL](https://www.stacksync.com/integrations/elasticsearch-and-postgresql) ### CRM · 45 - [PostgreSQL and 6sense](https://www.stacksync.com/integrations/6sense-and-postgresql) - [PostgreSQL and Affinity](https://www.stacksync.com/integrations/affinity-and-postgresql) - [PostgreSQL and Apollo.io](https://www.stacksync.com/integrations/apollo-io-and-postgresql) - [PostgreSQL and Attio](https://www.stacksync.com/integrations/attio-and-postgresql) - [PostgreSQL and Chorusai](https://www.stacksync.com/integrations/chorusai-and-postgresql) - [PostgreSQL and Clari](https://www.stacksync.com/integrations/clari-and-postgresql) - [PostgreSQL and Clearbit](https://www.stacksync.com/integrations/clearbit-and-postgresql) - [PostgreSQL and Close](https://www.stacksync.com/integrations/close-and-postgresql) - [PostgreSQL and Copper CRM](https://www.stacksync.com/integrations/copper-crm-and-postgresql) - [PostgreSQL and Creatio CRM](https://www.stacksync.com/integrations/creatio-crm-and-postgresql) - [PostgreSQL and Crustdata](https://www.stacksync.com/integrations/crustdata-and-postgresql) - [PostgreSQL and DealCloud](https://www.stacksync.com/integrations/dealcloud-and-postgresql) - [PostgreSQL and Dun & Bradstreet](https://www.stacksync.com/integrations/dun-bradstreet-and-postgresql) - [PostgreSQL and Folk CRM](https://www.stacksync.com/integrations/folk-crm-and-postgresql) - [PostgreSQL and Freshsales](https://www.stacksync.com/integrations/freshsales-and-postgresql) - [PostgreSQL and Freshworks CRM](https://www.stacksync.com/integrations/freshworks-crm-and-postgresql) - [PostgreSQL and Gladly](https://www.stacksync.com/integrations/gladly-and-postgresql) - [PostgreSQL and Gong](https://www.stacksync.com/integrations/gong-and-postgresql) - [PostgreSQL and Gorgias](https://www.stacksync.com/integrations/gorgias-and-postgresql) - [PostgreSQL and HubSpot](https://www.stacksync.com/integrations/hubspot-and-postgresql) - [PostgreSQL and Infor CRM](https://www.stacksync.com/integrations/infor-crm-and-postgresql) - [PostgreSQL and Insightly](https://www.stacksync.com/integrations/insightly-and-postgresql) - [PostgreSQL and Intercom](https://www.stacksync.com/integrations/intercom-and-postgresql) - [PostgreSQL and Kommo](https://www.stacksync.com/integrations/kommo-and-postgresql) - [PostgreSQL and Kustomer](https://www.stacksync.com/integrations/kustomer-and-postgresql) - [PostgreSQL and Microsoft Dynamics 365 Sales](https://www.stacksync.com/integrations/microsoft-dynamics-365-sales-and-postgresql) - [PostgreSQL and Nimble](https://www.stacksync.com/integrations/nimble-and-postgresql) - [PostgreSQL and Nutshell](https://www.stacksync.com/integrations/nutshell-and-postgresql) - [PostgreSQL and Oracle CX Sales](https://www.stacksync.com/integrations/oracle-cx-sales-and-postgresql) - [PostgreSQL and Outreach](https://www.stacksync.com/integrations/outreach-and-postgresql) - [PostgreSQL and Pipedrive](https://www.stacksync.com/integrations/pipedrive-and-postgresql) - [PostgreSQL and Salesforce](https://www.stacksync.com/integrations/postgresql-and-salesforce) - [PostgreSQL and Salesloft](https://www.stacksync.com/integrations/postgresql-and-salesloft) - [PostgreSQL and SAP Sales Cloud](https://www.stacksync.com/integrations/postgresql-and-sap-sales-cloud) - [PostgreSQL and Seismic](https://www.stacksync.com/integrations/postgresql-and-seismic) - [PostgreSQL and Shopify](https://www.stacksync.com/integrations/postgresql-and-shopify) - [PostgreSQL and Streak CRM](https://www.stacksync.com/integrations/postgresql-and-streak-crm) - [PostgreSQL and SugarCRM](https://www.stacksync.com/integrations/postgresql-and-sugarcrm) - [PostgreSQL and Twenty CRM](https://www.stacksync.com/integrations/postgresql-and-twenty-crm) - [PostgreSQL and Veeva CRM](https://www.stacksync.com/integrations/postgresql-and-veeva-crm) - [PostgreSQL and Vitally](https://www.stacksync.com/integrations/postgresql-and-vitally) - [PostgreSQL and Vtiger CRM](https://www.stacksync.com/integrations/postgresql-and-vtiger-crm) - [PostgreSQL and Xactly](https://www.stacksync.com/integrations/postgresql-and-xactly) - [PostgreSQL and Zoho CRM](https://www.stacksync.com/integrations/postgresql-and-zoho-crm) - [PostgreSQL and ZoomInfo](https://www.stacksync.com/integrations/postgresql-and-zoominfo) ### ERP · 42 - [PostgreSQL and Acumatica](https://www.stacksync.com/integrations/acumatica-and-postgresql) - [PostgreSQL and Blue Yonder WMS](https://www.stacksync.com/integrations/blue-yonder-wms-and-postgresql) - [PostgreSQL and Brightpearl](https://www.stacksync.com/integrations/brightpearl-and-postgresql) - [PostgreSQL and Cetec ERP](https://www.stacksync.com/integrations/cetec-erp-and-postgresql) - [PostgreSQL and Cin7](https://www.stacksync.com/integrations/cin7-and-postgresql) - [PostgreSQL and DEAR Inventory](https://www.stacksync.com/integrations/dear-inventory-and-postgresql) - [PostgreSQL and Deposco](https://www.stacksync.com/integrations/deposco-and-postgresql) - [PostgreSQL and Dynamics 365 Business Central](https://www.stacksync.com/integrations/microsoft-dynamics-365-business-central-and-postgresql) - [PostgreSQL and Dynamics 365 F&O](https://www.stacksync.com/integrations/dynamics-365-finance-operations-and-postgresql) - [PostgreSQL and Epicor ERP](https://www.stacksync.com/integrations/epicor-erp-and-postgresql) - [PostgreSQL and Extensiv (3PL Central)](https://www.stacksync.com/integrations/extensiv-3pl-central-and-postgresql) - [PostgreSQL and Fishbowl Manufacturing](https://www.stacksync.com/integrations/fishbowl-manufacturing-and-postgresql) - [PostgreSQL and Infor CloudSuite](https://www.stacksync.com/integrations/infor-cloudsuite-and-postgresql) - [PostgreSQL and Infor LN](https://www.stacksync.com/integrations/infor-ln-and-postgresql) - [PostgreSQL and Infor M3](https://www.stacksync.com/integrations/infor-m3-and-postgresql) - [PostgreSQL and Infor WMS](https://www.stacksync.com/integrations/infor-wms-and-postgresql) - [PostgreSQL and IQMS (DELMIAworks)](https://www.stacksync.com/integrations/iqms-delmiaworks-and-postgresql) - [PostgreSQL and Linnworks](https://www.stacksync.com/integrations/linnworks-and-postgresql) - [PostgreSQL and Logiwa WMS](https://www.stacksync.com/integrations/logiwa-wms-and-postgresql) - [PostgreSQL and Macola ERP](https://www.stacksync.com/integrations/macola-erp-and-postgresql) - [PostgreSQL and Manhattan Associates WMS](https://www.stacksync.com/integrations/manhattan-associates-wms-and-postgresql) - [PostgreSQL and Microsoft Dynamics GP](https://www.stacksync.com/integrations/microsoft-dynamics-gp-and-postgresql) - [PostgreSQL and Microsoft Dynamics NAV](https://www.stacksync.com/integrations/microsoft-dynamics-nav-and-postgresql) - [PostgreSQL and NetSuite](https://www.stacksync.com/integrations/netsuite-and-postgresql) - [PostgreSQL and Odoo](https://www.stacksync.com/integrations/odoo-and-postgresql) - [PostgreSQL and Oracle Fusion ERP](https://www.stacksync.com/integrations/oracle-fusion-erp-and-postgresql) - [PostgreSQL and Plex ERP](https://www.stacksync.com/integrations/plex-erp-and-postgresql) - [PostgreSQL and QAD ERP](https://www.stacksync.com/integrations/postgresql-and-qad-erp) - [PostgreSQL and Rootstock ERP](https://www.stacksync.com/integrations/postgresql-and-rootstock-erp) - [PostgreSQL and Sage 100](https://www.stacksync.com/integrations/postgresql-and-sage-100) - [PostgreSQL and Sage 300](https://www.stacksync.com/integrations/postgresql-and-sage-300) - [PostgreSQL and Sage Intacct](https://www.stacksync.com/integrations/postgresql-and-sage-intacct) - [PostgreSQL and Sage X3](https://www.stacksync.com/integrations/postgresql-and-sage-x3) - [PostgreSQL and SAP](https://www.stacksync.com/integrations/postgresql-and-sap) - [PostgreSQL and SAP Business ByDesign](https://www.stacksync.com/integrations/postgresql-and-sap-business-bydesign) - [PostgreSQL and SAP Business One](https://www.stacksync.com/integrations/postgresql-and-sap-business-one) - [PostgreSQL and SAP S/4HANA](https://www.stacksync.com/integrations/postgresql-and-sap-s4hana) - [PostgreSQL and Snapfulfil](https://www.stacksync.com/integrations/postgresql-and-snapfulfil) - [PostgreSQL and SuiteAnalytics](https://www.stacksync.com/integrations/postgresql-and-suite-analytics) - [PostgreSQL and Syspro](https://www.stacksync.com/integrations/postgresql-and-syspro) - [PostgreSQL and TikTok Shop](https://www.stacksync.com/integrations/postgresql-and-tiktok) - [PostgreSQL and Unleashed Software](https://www.stacksync.com/integrations/postgresql-and-unleashed-software) ### Database · 49 - [PostgreSQL and Airtable](https://www.stacksync.com/integrations/airtable-and-postgresql) - [PostgreSQL and Amazon Aurora](https://www.stacksync.com/integrations/amazon-aurora-and-postgresql) - [PostgreSQL and Amazon DynamoDB](https://www.stacksync.com/integrations/dynamo-db-and-postgresql) - [PostgreSQL and Amazon DynamoDB](https://www.stacksync.com/integrations/amazon-dynamodb-and-postgresql) - [PostgreSQL and Amazon Lightsail](https://www.stacksync.com/integrations/amazon-lightsail-and-postgresql) - [PostgreSQL and Amazon RDS](https://www.stacksync.com/integrations/amazon-rds-and-postgresql) - [PostgreSQL and Apache Cassandra](https://www.stacksync.com/integrations/apache-cassandra-and-postgresql) - [PostgreSQL and AWS Aurora MySQL](https://www.stacksync.com/integrations/aws-aurora-mysql-and-postgresql) - [PostgreSQL and AWS Aurora PostgreSQL](https://www.stacksync.com/integrations/aws-aurora-postgresql-and-postgresql) - [PostgreSQL and Azure Cosmos DB](https://www.stacksync.com/integrations/azure-cosmos-db-and-postgresql) - [PostgreSQL and Azure SQL Database](https://www.stacksync.com/integrations/azure-sql-database-and-postgresql) - [PostgreSQL and Citus](https://www.stacksync.com/integrations/citus-and-postgresql) - [PostgreSQL and CockroachDB](https://www.stacksync.com/integrations/cockroachdb-and-postgresql) - [PostgreSQL and Couchbase](https://www.stacksync.com/integrations/couchbase-and-postgresql) - [PostgreSQL and DuckDB](https://www.stacksync.com/integrations/duckdb-and-postgresql) - [PostgreSQL and Elasticsearch](https://www.stacksync.com/integrations/elasticsearch-and-postgresql) - [PostgreSQL and Firebase](https://www.stacksync.com/integrations/firebase-and-postgresql) - [PostgreSQL and Google AlloyDB](https://www.stacksync.com/integrations/google-alloydb-and-postgresql) - [PostgreSQL and Google Cloud Spanner](https://www.stacksync.com/integrations/google-cloud-spanner-and-postgresql) - [PostgreSQL and Google Cloud SQL](https://www.stacksync.com/integrations/google-cloud-sql-and-postgresql) - [PostgreSQL and IBM AS/400](https://www.stacksync.com/integrations/ibm-as400-and-postgresql) - [PostgreSQL and IBM Db2](https://www.stacksync.com/integrations/ibm-db2-and-postgresql) - [PostgreSQL and IBM Informix](https://www.stacksync.com/integrations/ibm-informix-and-postgresql) - [PostgreSQL and InfluxDB](https://www.stacksync.com/integrations/influxdb-and-postgresql) - [PostgreSQL and InterSystems IRIS](https://www.stacksync.com/integrations/intersystems-iris-and-postgresql) - [PostgreSQL and JDBC](https://www.stacksync.com/integrations/jdbc-and-postgresql) - [PostgreSQL and MariaDB](https://www.stacksync.com/integrations/mariadb-and-postgresql) - [PostgreSQL and MarkLogic](https://www.stacksync.com/integrations/marklogic-and-postgresql) - [PostgreSQL and MongoDB](https://www.stacksync.com/integrations/mongodb-and-postgresql) - [PostgreSQL and MySQL](https://www.stacksync.com/integrations/mysql-and-postgresql) - [PostgreSQL and Neo4j](https://www.stacksync.com/integrations/neo4j-and-postgresql) - [PostgreSQL and OCI Database (Oracle Cloud)](https://www.stacksync.com/integrations/oci-database-and-postgresql) - [PostgreSQL and OpenSearch](https://www.stacksync.com/integrations/opensearch-and-postgresql) - [PostgreSQL and Oracle DB](https://www.stacksync.com/integrations/oracle-db-and-postgresql) - [PostgreSQL and Postgres Heroku](https://www.stacksync.com/integrations/postgres-heroku-and-postgresql) - [PostgreSQL and RavenDB](https://www.stacksync.com/integrations/postgresql-and-ravendb) - [PostgreSQL and Redis Enterprise](https://www.stacksync.com/integrations/postgresql-and-redis-enterprise) - [PostgreSQL and Reltio](https://www.stacksync.com/integrations/postgresql-and-reltio) - [PostgreSQL and Render Postgres](https://www.stacksync.com/integrations/postgresql-and-render-postgres) - [PostgreSQL and SAP ASE (Sybase)](https://www.stacksync.com/integrations/postgresql-and-sap-ase-sybase) - [PostgreSQL and SAP HANA](https://www.stacksync.com/integrations/postgresql-and-sap-hana) - [PostgreSQL and Scaleway Postgres](https://www.stacksync.com/integrations/postgresql-and-scaleway-postgres) - [PostgreSQL and SingleStore](https://www.stacksync.com/integrations/postgresql-and-singlestore) - [PostgreSQL and SQL Server](https://www.stacksync.com/integrations/postgresql-and-sql-server) - [PostgreSQL and Supabase](https://www.stacksync.com/integrations/postgresql-and-supabase) - [PostgreSQL and TiDB](https://www.stacksync.com/integrations/postgresql-and-tidb) - [PostgreSQL and TimescaleDB](https://www.stacksync.com/integrations/postgresql-and-timescaledb) - [PostgreSQL and VoltDB](https://www.stacksync.com/integrations/postgresql-and-voltdb) - [PostgreSQL and YugabyteDB](https://www.stacksync.com/integrations/postgresql-and-yugabytedb) ### Data warehouse · 30 - [PostgreSQL and Actian Vector](https://www.stacksync.com/integrations/actian-vector-and-postgresql) - [PostgreSQL and Amazon Redshift](https://www.stacksync.com/integrations/amazon-redshift-and-postgresql) - [PostgreSQL and Amazon S3](https://www.stacksync.com/integrations/aws-s3-and-postgresql) - [PostgreSQL and Apache Doris](https://www.stacksync.com/integrations/apache-doris-and-postgresql) - [PostgreSQL and Apache Druid](https://www.stacksync.com/integrations/apache-druid-and-postgresql) - [PostgreSQL and Apache Hive](https://www.stacksync.com/integrations/apache-hive-and-postgresql) - [PostgreSQL and Apache Impala](https://www.stacksync.com/integrations/apache-impala-and-postgresql) - [PostgreSQL and Apache Kylin](https://www.stacksync.com/integrations/apache-kylin-and-postgresql) - [PostgreSQL and Apache Pinot](https://www.stacksync.com/integrations/apache-pinot-and-postgresql) - [PostgreSQL and Azure Synapse Analytics](https://www.stacksync.com/integrations/azure-synapse-analytics-and-postgresql) - [PostgreSQL and BigQuery](https://www.stacksync.com/integrations/bigquery-and-postgresql) - [PostgreSQL and ClickHouse](https://www.stacksync.com/integrations/clickhouse-and-postgresql) - [PostgreSQL and Cloudera Data Platform](https://www.stacksync.com/integrations/cloudera-data-platform-and-postgresql) - [PostgreSQL and Databricks](https://www.stacksync.com/integrations/databricks-and-postgresql) - [PostgreSQL and Dremio](https://www.stacksync.com/integrations/dremio-and-postgresql) - [PostgreSQL and Exasol](https://www.stacksync.com/integrations/exasol-and-postgresql) - [PostgreSQL and Firebolt](https://www.stacksync.com/integrations/firebolt-and-postgresql) - [PostgreSQL and Google Cloud Platform](https://www.stacksync.com/integrations/google-cloud-platform-and-postgresql) - [PostgreSQL and Greenplum](https://www.stacksync.com/integrations/greenplum-and-postgresql) - [PostgreSQL and IBM Netezza](https://www.stacksync.com/integrations/ibm-netezza-and-postgresql) - [PostgreSQL and Materialize](https://www.stacksync.com/integrations/materialize-and-postgresql) - [PostgreSQL and MotherDuck](https://www.stacksync.com/integrations/motherduck-and-postgresql) - [PostgreSQL and Rockset](https://www.stacksync.com/integrations/postgresql-and-rockset) - [PostgreSQL and Snowflake](https://www.stacksync.com/integrations/postgresql-and-snowflake) - [PostgreSQL and Starburst Enterprise](https://www.stacksync.com/integrations/postgresql-and-starburst-enterprise) - [PostgreSQL and StarRocks](https://www.stacksync.com/integrations/postgresql-and-starrocks) - [PostgreSQL and Teradata Vantage](https://www.stacksync.com/integrations/postgresql-and-teradata-vantage) - [PostgreSQL and Tinybird](https://www.stacksync.com/integrations/postgresql-and-tinybird) - [PostgreSQL and Vertica](https://www.stacksync.com/integrations/postgresql-and-vertica) - [PostgreSQL and Yellowbrick](https://www.stacksync.com/integrations/postgresql-and-yellowbrick) ### Business productivity · 41 - [PostgreSQL and Adobe Sign](https://www.stacksync.com/integrations/adobe-sign-and-postgresql) - [PostgreSQL and Agiloft](https://www.stacksync.com/integrations/agiloft-and-postgresql) - [PostgreSQL and Amazon Seller Central](https://www.stacksync.com/integrations/amazon-seller-central-and-postgresql) - [PostgreSQL and Asana](https://www.stacksync.com/integrations/asana-and-postgresql) - [PostgreSQL and Atlassian](https://www.stacksync.com/integrations/atlassian-and-postgresql) - [PostgreSQL and Aviato](https://www.stacksync.com/integrations/aviato-and-postgresql) - [PostgreSQL and BetterContact](https://www.stacksync.com/integrations/better-contact-and-postgresql) - [PostgreSQL and Braze](https://www.stacksync.com/integrations/braze-and-postgresql) - [PostgreSQL and Campfire](https://www.stacksync.com/integrations/campfire-and-postgresql) - [PostgreSQL and ConnectWise](https://www.stacksync.com/integrations/connectwise-and-postgresql) - [PostgreSQL and Customer.io](https://www.stacksync.com/integrations/customer-io-and-postgresql) - [PostgreSQL and Docusign](https://www.stacksync.com/integrations/docusign-and-postgresql) - [PostgreSQL and eClinicalWorks](https://www.stacksync.com/integrations/eclinicalworks-and-postgresql) - [PostgreSQL and Front](https://www.stacksync.com/integrations/front-and-postgresql) - [PostgreSQL and FullEnrich](https://www.stacksync.com/integrations/full-enrich-and-postgresql) - [PostgreSQL and Gainsight](https://www.stacksync.com/integrations/gainsight-and-postgresql) - [PostgreSQL and Gatekeeper](https://www.stacksync.com/integrations/gatekeeper-and-postgresql) - [PostgreSQL and GitHub](https://www.stacksync.com/integrations/github-and-postgresql) - [PostgreSQL and Google Sheets](https://www.stacksync.com/integrations/google-sheets-and-postgresql) - [PostgreSQL and Ironclad](https://www.stacksync.com/integrations/ironclad-and-postgresql) - [PostgreSQL and Klaviyo](https://www.stacksync.com/integrations/klaviyo-and-postgresql) - [PostgreSQL and Lemlist](https://www.stacksync.com/integrations/lemlist-and-postgresql) - [PostgreSQL and Lusha](https://www.stacksync.com/integrations/lusha-and-postgresql) - [PostgreSQL and Microsoft 365](https://www.stacksync.com/integrations/microsoft-365-and-postgresql) - [PostgreSQL and Microsoft Dynamics 365](https://www.stacksync.com/integrations/microsoft-dynamics-365-and-postgresql) - [PostgreSQL and Microsoft Teams](https://www.stacksync.com/integrations/microsoft-teams-and-postgresql) - [PostgreSQL and Monday](https://www.stacksync.com/integrations/monday-and-postgresql) - [PostgreSQL and NextGen Healthcare](https://www.stacksync.com/integrations/nextgen-healthcare-and-postgresql) - [PostgreSQL and Notion](https://www.stacksync.com/integrations/notion-and-postgresql) - [PostgreSQL and Orderful](https://www.stacksync.com/integrations/orderful-and-postgresql) - [PostgreSQL and Quip](https://www.stacksync.com/integrations/postgresql-and-quip) - [PostgreSQL and Resend](https://www.stacksync.com/integrations/postgresql-and-resend) - [PostgreSQL and SendGrid](https://www.stacksync.com/integrations/postgresql-and-sendgrid) - [PostgreSQL and ServiceMax](https://www.stacksync.com/integrations/postgresql-and-servicemax) - [PostgreSQL and ServiceNow](https://www.stacksync.com/integrations/postgresql-and-servicenow) - [PostgreSQL and Slack](https://www.stacksync.com/integrations/postgresql-and-slack) - [PostgreSQL and Smartsheet](https://www.stacksync.com/integrations/postgresql-and-smartsheet) - [PostgreSQL and SysAid](https://www.stacksync.com/integrations/postgresql-and-sysaid) - [PostgreSQL and Twilio](https://www.stacksync.com/integrations/postgresql-and-twilio) - [PostgreSQL and Wrike](https://www.stacksync.com/integrations/postgresql-and-wrike) - [PostgreSQL and Zendesk](https://www.stacksync.com/integrations/postgresql-and-zendesk) ### Accounting and finance · 17 - [PostgreSQL and Adyen](https://www.stacksync.com/integrations/adyen-and-postgresql) - [PostgreSQL and Anaplan](https://www.stacksync.com/integrations/anaplan-and-postgresql) - [PostgreSQL and BILL](https://www.stacksync.com/integrations/bill-and-postgresql) - [PostgreSQL and Braintree](https://www.stacksync.com/integrations/braintree-and-postgresql) - [PostgreSQL and Chargebee](https://www.stacksync.com/integrations/chargebee-and-postgresql) - [PostgreSQL and Coupa](https://www.stacksync.com/integrations/coupa-and-postgresql) - [PostgreSQL and Hyperline](https://www.stacksync.com/integrations/hyperline-and-postgresql) - [PostgreSQL and LogiSense](https://www.stacksync.com/integrations/logisense-and-postgresql) - [PostgreSQL and Navan](https://www.stacksync.com/integrations/navan-and-postgresql) - [PostgreSQL and Pigment](https://www.stacksync.com/integrations/pigment-and-postgresql) - [PostgreSQL and QuickBooks](https://www.stacksync.com/integrations/postgresql-and-quickbooks) - [PostgreSQL and Ramp](https://www.stacksync.com/integrations/postgresql-and-ramp) - [PostgreSQL and Recurly](https://www.stacksync.com/integrations/postgresql-and-recurly) - [PostgreSQL and Rillet](https://www.stacksync.com/integrations/postgresql-and-rillet) - [PostgreSQL and Stripe](https://www.stacksync.com/integrations/postgresql-and-stripe) - [PostgreSQL and Workday](https://www.stacksync.com/integrations/postgresql-and-workday) - [PostgreSQL and Zuora](https://www.stacksync.com/integrations/postgresql-and-zuora) ### AI · 5 - [PostgreSQL and Anthropic](https://www.stacksync.com/integrations/anthropic-and-postgresql) - [PostgreSQL and Autopilot](https://www.stacksync.com/integrations/autopilot-and-postgresql) - [PostgreSQL and Azure OpenAI](https://www.stacksync.com/integrations/azure-openai-and-postgresql) - [PostgreSQL and OpenAI](https://www.stacksync.com/integrations/openai-and-postgresql) - [PostgreSQL and Pinecone](https://www.stacksync.com/integrations/pinecone-and-postgresql) ### Analytics · 7 - [PostgreSQL and Adobe Analytics](https://www.stacksync.com/integrations/adobeanalytics-and-postgresql) - [PostgreSQL and Microsoft Power BI](https://www.stacksync.com/integrations/microsoft-power-bi-and-postgresql) - [PostgreSQL and Mixpanel](https://www.stacksync.com/integrations/mixpanel-and-postgresql) - [PostgreSQL and Pendo](https://www.stacksync.com/integrations/pendo-and-postgresql) - [PostgreSQL and Splunk](https://www.stacksync.com/integrations/postgresql-and-splunk) - [PostgreSQL and Tableau](https://www.stacksync.com/integrations/postgresql-and-tableau) - [PostgreSQL and Treasure Data](https://www.stacksync.com/integrations/postgresql-and-treasuredata) ### Communications · 5 - [PostgreSQL and Aircall](https://www.stacksync.com/integrations/aircall-and-postgresql) - [PostgreSQL and Amazon SES](https://www.stacksync.com/integrations/amazon-ses-and-postgresql) - [PostgreSQL and Infobip](https://www.stacksync.com/integrations/infobip-and-postgresql) - [PostgreSQL and RingCentral](https://www.stacksync.com/integrations/postgresql-and-ringcentral) - [PostgreSQL and Zoom](https://www.stacksync.com/integrations/postgresql-and-zoom) ### Developer tools · 11 - [PostgreSQL and Azure Service Bus](https://www.stacksync.com/integrations/azure-service-bus-and-postgresql) - [PostgreSQL and Datadog](https://www.stacksync.com/integrations/datadog-and-postgresql) - [PostgreSQL and Google Cloud Pub/Sub](https://www.stacksync.com/integrations/google-pubsub-and-postgresql) - [PostgreSQL and Jira](https://www.stacksync.com/integrations/jira-and-postgresql) - [PostgreSQL and JMS](https://www.stacksync.com/integrations/jms-and-postgresql) - [PostgreSQL and LDAP](https://www.stacksync.com/integrations/ldap-and-postgresql) - [PostgreSQL and Microsoft Graph](https://www.stacksync.com/integrations/microsoft-graph-and-postgresql) - [PostgreSQL and New Relic](https://www.stacksync.com/integrations/newrelic-and-postgresql) - [PostgreSQL and Opsgenie](https://www.stacksync.com/integrations/opsgenie-and-postgresql) - [PostgreSQL and PagerDuty](https://www.stacksync.com/integrations/pagerduty-and-postgresql) - [PostgreSQL and RabbitMQ](https://www.stacksync.com/integrations/postgresql-and-rabbitmq) ### E-commerce · 8 - [PostgreSQL and Akeneo](https://www.stacksync.com/integrations/akeneo-and-postgresql) - [PostgreSQL and BigCommerce](https://www.stacksync.com/integrations/bigcommerce-and-postgresql) - [PostgreSQL and ChannelEngine](https://www.stacksync.com/integrations/channelengine-and-postgresql) - [PostgreSQL and EasyPost](https://www.stacksync.com/integrations/easypost-and-postgresql) - [PostgreSQL and Magento](https://www.stacksync.com/integrations/magento-and-postgresql) - [PostgreSQL and NuORDER](https://www.stacksync.com/integrations/nuorder-and-postgresql) - [PostgreSQL and Shipwire](https://www.stacksync.com/integrations/postgresql-and-shipwire) - [PostgreSQL and Shopware](https://www.stacksync.com/integrations/postgresql-and-shopware) ### Human resources · 14 - [PostgreSQL and BambooHR](https://www.stacksync.com/integrations/bamboohr-and-postgresql) - [PostgreSQL and Ceridian Dayforce](https://www.stacksync.com/integrations/ceridian-dayforce-and-postgresql) - [PostgreSQL and D2L Brightspace](https://www.stacksync.com/integrations/d2l-brightspace-and-postgresql) - [PostgreSQL and Greenhouse](https://www.stacksync.com/integrations/greenhouse-and-postgresql) - [PostgreSQL and Hibob](https://www.stacksync.com/integrations/hibob-and-postgresql) - [PostgreSQL and Jobvite](https://www.stacksync.com/integrations/jobvite-and-postgresql) - [PostgreSQL and Lever](https://www.stacksync.com/integrations/lever-and-postgresql) - [PostgreSQL and Namely](https://www.stacksync.com/integrations/namely-and-postgresql) - [PostgreSQL and Oracle Fusion Cloud HCM](https://www.stacksync.com/integrations/oracle-fusion-cloud-hcm-and-postgresql) - [PostgreSQL and Paylocity](https://www.stacksync.com/integrations/paylocity-and-postgresql) - [PostgreSQL and SmartRecruiters](https://www.stacksync.com/integrations/postgresql-and-smartrecruiters) - [PostgreSQL and Success Factors](https://www.stacksync.com/integrations/postgresql-and-success-factors) - [PostgreSQL and UKG Pro](https://www.stacksync.com/integrations/postgresql-and-ukg-pro) - [PostgreSQL and UKG Ready](https://www.stacksync.com/integrations/postgresql-and-ukg-ready) ### Marketing · 9 - [PostgreSQL and Bingads](https://www.stacksync.com/integrations/bingads-and-postgresql) - [PostgreSQL and Cvent](https://www.stacksync.com/integrations/cvent-and-postgresql) - [PostgreSQL and Demandbase](https://www.stacksync.com/integrations/demandbase-and-postgresql) - [PostgreSQL and Eloqua](https://www.stacksync.com/integrations/eloqua-and-postgresql) - [PostgreSQL and Iterable](https://www.stacksync.com/integrations/iterable-and-postgresql) - [PostgreSQL and Marketo](https://www.stacksync.com/integrations/marketo-and-postgresql) - [PostgreSQL and RollWorks](https://www.stacksync.com/integrations/postgresql-and-rollworks) - [PostgreSQL and Salesforce Marketing Cloud](https://www.stacksync.com/integrations/postgresql-and-salesforce-marketing-cloud) - [PostgreSQL and Twitter Ads](https://www.stacksync.com/integrations/postgresql-and-twitter-ads) ### Security and identity · 6 - [PostgreSQL and Active Directory](https://www.stacksync.com/integrations/active-directory-and-postgresql) - [PostgreSQL and Auth0](https://www.stacksync.com/integrations/auth0-and-postgresql) - [PostgreSQL and Azure Active Directory](https://www.stacksync.com/integrations/azure-active-directory-and-postgresql) - [PostgreSQL and JumpCloud](https://www.stacksync.com/integrations/jumpcloud-and-postgresql) - [PostgreSQL and Okta](https://www.stacksync.com/integrations/okta-and-postgresql) - [PostgreSQL and OneLogin](https://www.stacksync.com/integrations/onelogin-and-postgresql) ### Storage · 4 - [PostgreSQL and Amazon S3](https://www.stacksync.com/integrations/amazon-s3-and-postgresql) - [PostgreSQL and Box](https://www.stacksync.com/integrations/box-and-postgresql) - [PostgreSQL and Egnyte](https://www.stacksync.com/integrations/egnyte-and-postgresql) - [PostgreSQL and SharePoint](https://www.stacksync.com/integrations/postgresql-and-sharepoint) SECURITY ## Security teams trust Stacksync As a data company, we understand the importance of keeping your data secure. Stacksync is built with security best practices to keep your data safe at every layer, and is DPF-certified for US, EU, UK and CH data transfers. [Learn more about security](https://www.stacksync.com/security) | | | | --- | --- | | | SOC 2 Type II | | | ISO 27001 | | | HIPAA BAA | | | GDPR | | | CCPA | | | DPF US-EU-UK-CH | → SECURITY WITH BENEFITS ### SSO & SCIM Let your users access Stacksync from your centralized user management systems. Works with Okta, Azure, Google SSO and more. ### Alerts Immediately get alerted about record syncing issues over email, Slack, PagerDuty and WhatsApp. Resolve issues from a centralized dashboard with retry and revert options. ### Secure connection options Securely connects to your systems with: [OAuth 2](https://www.stacksync.com/security) [SSH Tunnelling](https://docs.stacksync.com/two-way-sync/connectors/setup-options/ssh-tunneling) [SSL certificates](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/amazon-rds/ensuring-secure-rds-connections-with-ssl-certificate) [IP Whitelisting](https://docs.stacksync.com/two-way-sync/connectors/setup-options/ip-whitelisting) [VPN gateway](https://docs.stacksync.com/two-way-sync/legal/service-consumption-tables#:~:text=%E2%9C%93-,VPN%20gateway,-%2D) [VPC peering](https://www.stacksync.com/security) and more ## Connect the systems your business runs on. Build your next workflow with Stacksync. [Book a demo](https://www.stacksync.com/book-a-demo) [Get started](https://app.stacksync.com/)