PostgreSQL is a powerful, open-source object-relational database system. Meroxa will automatically discover the version, capabilities, and permission of the added PostgreSQL Resource and will create the appropriate connection to capture data changes.
We support the following PostgreSQL environments:
- Generic PostgreSQL
- Amazon RDS
The Meroxa Platform has been tested against the following PostgreSQL versions:
To add a PostgreSQL resource with Logical Replication enabled:
postgresDB is a human-friendly name to represent the resource within Meroxa. Feel free to change as desired.
In the command above, replace the following variables with valid credentials from your PostgreSQL environment:
- $PG_USER - PostgreSQL Username
- $PG_PASS - PostgreSQL Password
- $PG_URL - PostgreSQL URL
- $PG_DB - PostgreSQL Database Name
- $PG_PORT - PostgreSQL Port (e.g., 5432).
To configure Postgres as a destination:
The command above creates a new Connector called
to-pg, sets the destination to a resource named
postgresDB and configures the Input Stream.