Skip to main content

Preparing to run the PostgreSQL collector

Setting up pre-requisites for running the collector

Make sure that the machine from where you are running the collector meets the following hardware and software requirements.

Table 1.



Hardware (for on-premise runs only)

Note: The following specs are based upon running one collector process at a time. Please adjust the hardware if you are running multiple collectors at the same time.


8 GB


2 Ghz processor

Software (for on-premise runs only)


Click here to get Docker. specific objects (for both cloud and on-premise runs)


You must have a ddw-catalogs dataset set up to hold your catalog files when you are done running the collector.

If you are using Catalog Toolkit , follow these instructions to prepare the datasets for collectors.

Setting up permissions

Run the following SQL statements to set up a new user with appropriate permissions to harvest from PostgreSQL

  1. Create a new role.

    CREATE ROLE ddw_role;
  2. Run the following SQL statement to grant permissions to the new role for each database and schema.

    GRANT USAGE ON SCHEMA "<schemaName>" TO ddw_role;
    GRANT SELECT ON ALL TABLES IN SCHEMA "<schemaName>" TO ddw_role;
  3. Create a new user.

    CREATE USER ddw_user PASSWORD "<password>";
    GRANT ddw_role TO ddw_user;