Skip to main content


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:

The Meroxa Platform has been tested against the following PostgreSQL versions:

  • 9.6.x
  • 10.x
  • 11.x
  • 12.x

Adding Resource#

To add a PostgreSQL resource with Logical Replication enabled:

meroxa resource add postgresDB --type postgres -u postgres://$PG_USER:$PG_PASS@$PG_URL:$PG_PORT/$PG_DB

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).

Destination Configuration#

To configure Postgres as a destination:

meroxa connector create to-pg --to postgresDB --input $STREAM_NAME

The command above creates a new Connector called to-pg, sets the destination to a resource named postgresDB and configures the Input Stream.