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.
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
Create a new role.
CREATE ROLE ddw_role;
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;
Create a new user.
CREATE USER ddw_user PASSWORD "<password>"; GRANT ddw_role TO ddw_user;