PostgreSQL Writer.

DBConvert Streams Writer supports PostgreSQL databases version 10 and later as a target database for writing data collected from a source.

Follow the instructions on this page to set up PostgreSQL as a target.

Prerequisites.

A running PostgreSQL instance.
IP addresses of DBConvert Streams services are whitelisted on the target Postgres server.

In the postgresql.conf file, add the DBS Target server IP addresses or * for the listen_addresses parameter to allow all IPs to connect.

Start editing the pg_hba.conf, which is usually found at /etc/postgresql/<version>/main/.

Add the IP address of DBConvert Streams Target Server or 0.0.0.0 to allow all IPs to connect.

host         all      <user>              0.0.0.0/0            md5

Here is an example of a JSON object describing Postgres configured as a target.

JSON

"target": {
    "type": "postgresql",
    "connection": "postgres://postgres:postgres@localhost:5432/destination"
  }