PostgreSQL
PostgreSQL is an open-source relational database management system.
You can read from PostgreSQL as follows, and write to any target supported by Striim. Typically, you will set up data pipelines that read from PostgreSQL in two phases—initial load, followed by continuous replication—as described in Building pipelines from PostgreSQL.
PostgreSQL feature summary
Feature | Initial load with Database Reader | Continuous real-time replication using PostgreSQL Reader | Continuous incremental replication with Incremental Batch Reader |
|---|---|---|---|
Supported versions and services | |||
PostgreSQL 9.4.x and later versions self-managed (for example, installed and managed on-premise or in a cloud VM) | ✔ | ✔ | ✔ |
Amazon Aurora with PostgreSQL compatibility | ✔ | ✔ | ✔ |
Amazon RDS for PostgreSQL | ✔ | ✔ | ✔ |
Azure Database for PostgreSQL | ✔ | ✔ | ✔ |
Azure Database for PostgreSQL - Flexible Server | ✔ | ✔ | ✔ |
Crunchy Postgres | ✔ | ✔ | ✔ |
Google AlloyDB for PostgreSQL | ✔ | ✔ | ✔ |
Google Cloud SQL for PostgreSQL | ✔ | ✔ | ✔ |
Neon | ✔ | ✔ | ✔ |
Security and governance | |||
connection profile | |||
Operations | |||
initial load | ✓ | ||
initial schema creation | with supported targets | ||
schema evolution | ✔ | ||
DML operations replicable in target | INSERT, UPDATE, DELETE, TRUNCATE | INSERT (UPDATE handled as INSERT, DELETE ignored) | |
Building applications / programmability | |||
automated pipelines | ✓ | ✓ | |
other wizards | initial load only | initial load only, change data capture only | initial load only |
Flow Designer | ✓ | ✓ | ✓ |
TQL | ✓ | ✓ | ✓ |
Runtime | |||
event type of output stream | WAEvent | WAEvent | WAEvent |
network connection fault tolerance | by JDBC driver | configurable automatic retries | by JDBC driver |
recovery | ✓ | ✓ | ✓ |
parallel threads | ✓ | ✓ | |
metrics & auditing | ✓ | ✓ | ✓ |