Docs/Streams/Database Guides/PostgreSQL

PostgreSQL Load Mode Guide

Use this page when PostgreSQL is the source for a Load workflow.

Load mode reads tables directly from PostgreSQL. It does not require WAL-based CDC setup. For background on Load mode, see Load Mode.

If you need continuous change capture, use PostgreSQL CDC Source Configuration instead.

Source requirements

The source user needs:

  • network reachability from the DBConvert Streams deployment
  • USAGE on the required schemas
  • SELECT on the source tables
  • SSL/TLS settings when required by the environment

No additional server-side configuration is needed — Load reads tables directly.

Example grants:

GRANT USAGE ON SCHEMA schema_name TO username;
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO username;

For connection and network setup, see PostgreSQL Server Configuration. To verify which schemas and tables are visible with the current privileges, open the connection in Data Explorer.

Configuration flow

  1. Create the PostgreSQL connection and test it from the Data Explorer sidebar (right-click → Test connection) or from the connection editor.
  2. Open the database in Data Explorer to confirm visible schemas and tables.
  3. In the stream wizard, select Conversion as the transfer mode.
  4. Select the tables to transfer — tables are grouped by schema, pick individual tables or use Select to select all within a schema.
    • Data Filter (per table) — select specific columns, set a row limit, add a WHERE filter, or define sort order.
    • Custom SQL — use custom queries when you need full control over the extraction.
  5. Configure target settings — structure options, schema policy, and write mode.
  6. Start the stream.

Load creates tables, indexes, and constraints on the target if they are missing. Control this with structure options.

Load also supports multi-source streams — combining data from several PostgreSQL, MySQL, or file connections in a single transfer.

Cloud-hosted PostgreSQL sources

If the source is provider-managed, use the provider page for network and service-specific details:

Before starting

PreviousCDC ConfigurationNextTarget Configuration