PostgreSQL
Sync PostgreSQL tables, views, and custom queries to your Shugyo digital twin without affecting production performance.
Available data
- Tables
- All tables you grant access to
- Views
- Standard and materialized views
- Custom queries
- Choose the data to extract
Sync methods
| Method | Captures deletes | Best for |
|---|---|---|
| CDC | Yes | Production databases, real-time |
| Incremental | No | Simpler setup, development |
| Full Refresh | Not applicable | Small tables, snapshots |
Connector features
Change data capture
Real-time replication via PostgreSQL's logical replication. Captures inserts, updates, and deletes.
Read-only access
The connector requests SELECT permissions and cannot write to source tables.
Write-ahead log reads
CDC reads the write-ahead log instead of querying source tables, which avoids query load on production tables.
Schema detection
Shugyo reads the PostgreSQL schema and maps its data structure.
Supported versions
- PostgreSQL 10, 11, 12, 13, 14, 15, 16
- Works with: Amazon RDS, Google Cloud SQL, Azure Database, self-hosted
Security
- SSL/TLS encrypted connections
- SSH tunnel support for on-premise
- SOC 2 Type II in progress
- You retain ownership of your data
INTEGRATION SETUP
Connect PostgreSQL to Shugyo
Tell us which PostgreSQL data you need and how often it should sync.