Skip to main content


The PostgreSQL connector for rudol allows you to connect your PostgreSQL 14+ databases.


Your PostgreSQL server instance must be publicly available through a resolvable DNS hostname or public IPv4, see Security Guidelines to know more on how to apply firewall restrictions

Connection parameters

HostnametextPublicly accesible PostgreSQL server DNS hostname
PortnumberServer port number (5432 by default)
UsertextPostgreSQL user name, see User permissions
PasswordpasswordPostgreSQL user password
DatabasetextPostgreSQL database you want to connect to

User permissions

In order to grant rudol the necessary permissions to fetch your database metadata we recommend you to create a new PostgreSQL user with access restricted only to the pg_catalog database.


Keep in mind that the created user would have the public Role by default so it will inherit its default permissions

Here is a sample code to create a new user for rudol with minimal permissions for metadata scan:

CREATE USER rudol_user PASSWORD 'super-secret-password';

GRANT USAGE ON SCHEMA "my_schema" to rudol_user


If you want to use Data Quality features these permissions won't be enough: you'll have to grant SELECT to each table you'd like to run tests for, and CREATE TEMPORARY TABLE to run validations without locking tables.

Restrict connections by IP Address

You can also restrict access to only accept incoming connections from the rudol public IP Address

To do this you will probably have to add a new record to your PostgreSQL pg_hba.conf. You can read more about this here.