PostgreSQL Setup Guide

To connect PostgreSQL and enable Aleph to query its data directly, Aleph needs a PostgreSQL user that will be used to read the tables and data.

We suggest creating a separate database user for Aleph, with only access to the tables you need to consume in Aleph. If you already have a database user for the finance team, we recommend assigning that user and the Aleph user the same role, so that any table that is made available to the finance user is also available in Aleph.

Once the user is created, you would need to provide your Aleph Account Manager with the following information:

• Database name

• Database connection string

If you have an IP whitelist, you must add our server IP 35.202.250.148 to the whitelist

To share this information securely, you can use Doppler Share or your preferred alternative. For security reasons, we recommend choosing an appropriate expiration time for the share link.

Important: the credential information is sensitive so only share it with authorized individuals.