PostgreSQL Connector

Connect PostgreSQL as a source or destination. Choose Full Refresh, Incremental, or CDC when you create a pipeline.

Supported sync modes

As source	Full Refresh	Incremental	CDC
	✅	✅	✅

As destination	Write modes
	Append, Upsert, Replace

Connection details

Field	Description
Host	Hostname or public IP
Port	Default `5432`
Database	Database name (not a placeholder — e.g. `postgres` or `zwiron_src`)
Username	Database user
Password	Database password
SSL mode	`require`, `verify-ca`, or `verify-full` for production

You can paste a URI to autofill fields:

postgres://USER:PASSWORD@HOST:5432/DATABASE

Special characters in the password are accepted as-is. Only encode @, /, ?, or # inside the password (%40, %2F, %3F, %23) — those characters delimit the URI.

Hosted mode networking

Zwiron Hosted connects from fixed egress IPs. If your Postgres uses an allowlist (Cloud SQL Authorized Networks, security groups, etc.):

Enable a public IP (private IP alone is not reachable from Hosted)
Allowlist all egress IPs as /32
Wait 1–2 minutes after saving, then Test connection

If Test fails with “The request did not reach the server,” the allowlist is almost always the cause — not the password. For databases with no public IP, use Agent mode.

Permissions

Source (read)

CREATE USER zwiron WITH PASSWORD 'your_password';
GRANT USAGE ON SCHEMA public TO zwiron;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO zwiron;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO zwiron;

Destination (read-write)

CREATE USER zwiron WITH PASSWORD 'your_password';
GRANT USAGE, CREATE ON SCHEMA public TO zwiron;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO zwiron;
ALTER DEFAULT PRIVILEGES IN SCHEMA public
  GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO zwiron;

CDC (extra)

ALTER USER zwiron WITH REPLICATION;

CREATE PUBLICATION zwiron_pub FOR ALL TABLES;
-- Or specific tables:
-- CREATE PUBLICATION zwiron_pub FOR TABLE orders, customers;

Enabling CDC

1. Turn on logical replication

Self-hosted — in postgresql.conf:

wal_level = logical
max_replication_slots = 5
max_wal_senders = 10

Restart Postgres, then:

SHOW wal_level;  -- must be "logical"

Managed — use the provider setting (below), not postgresql.conf.

2. In Zwiron

Save a Postgres source connection (with CDC grants above)
Create a job with sync mode CDC
Zwiron creates the replication slot automatically

Optional manual slot:

SELECT pg_create_logical_replication_slot('zwiron_slot', 'pgoutput');

Managed Postgres

Google Cloud SQL

Flag: cloudsql.logical_decoding = on (Edit instance → Flags)
User: create in Cloud SQL → Users, then:
ALTER USER zwiron WITH REPLICATION;
Hosted allowlist: Public IP + every egress IP as /32
Databases: create the DBs you need (e.g. source and destination on one instance is fine)
Apply source/destination grants above on each database

Amazon RDS / Aurora

Set rds.logical_replication = 1 in the parameter group:

GRANT rds_replication TO zwiron;

Also allowlist egress IPs on the security group for Hosted mode.

Supabase

Logical replication is on by default. Create a publication and grant REPLICATION to the Zwiron user.

Troubleshooting

The request did not reach the server

Network block. For Hosted, add all egress IPs to Authorized Networks / security group. For Agent, confirm the agent host can reach host:5432.

Access denied / password authentication failed

Wrong user or password, or the user was never created in the cloud console. Reset the password in Cloud SQL / RDS Users and paste it again.

Permission denied for table

Grant SELECT (and default privileges for new tables). For CDC, also REPLICATION + a publication.

CDC slot not advancing / lag growing

The job or agent is not consuming the slot. Confirm the CDC job is running. After a long outage you may need to drop and recreate the slot.

Connection refused (self-hosted)

Check pg_hba.conf allows the client IP:

host  all  zwiron  <client-ip>/32  md5

Getting Started

Guides

Core Concepts

Pipelines

Connectors

Platform

Support

PostgreSQL Connector

Supported sync modes

Connection details

Hosted mode networking

Permissions

Source (read)

Destination (read-write)

CDC (extra)

Enabling CDC

1. Turn on logical replication

2. In Zwiron

Managed Postgres

Google Cloud SQL

Amazon RDS / Aurora

Supabase

Troubleshooting

​Supported sync modes

​Connection details

​Hosted mode networking

​Permissions

​Source (read)

​Destination (read-write)

​CDC (extra)

​Enabling CDC

​1. Turn on logical replication

​2. In Zwiron

​Managed Postgres

​Google Cloud SQL

​Amazon RDS / Aurora

​Supabase

​Troubleshooting

​Related

Supported sync modes

Connection details

Hosted mode networking

Permissions

Source (read)

Destination (read-write)

CDC (extra)

Enabling CDC

1. Turn on logical replication

2. In Zwiron

Managed Postgres

Google Cloud SQL

Amazon RDS / Aurora

Supabase

Troubleshooting

Related