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.

Item

Requirement

Hardware

RAM

8 GB

CPU

2 Ghz processor

Software

Docker

Click here to get Docker.

Java Runtime Environment

OpenJDK 17 is supported and available here.

data.world specific objects

Dataset

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



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;