PostgreSQL

Required Information

To configure PostgreSQL in Alation, you will need the following information:

  • Hostname or IP address of your server

  • Port number

  • Database name

  • Service account with privileges listed

  • Query Log Ingestion setup

../../_images/DS_Postgres01.png

Preliminaries

Firewall Configuration:

  • Open outbound TCP port 5432 to PostgreSQL server

Service Account

Sample SQL to create an account:

CREATE USER alation WITH PASSWORD '[password]';

Metadata Extraction

GRANT USAGE ON SCHEMA PG_CATALOG TO alation;
GRANT SELECT ON ALL TABLES IN SCHEMA PG_CATALOG TO alation;
TABLE PROFILES
GRANT USAGE ON SCHEMA [schema] TO alation;
GRANT SELECT ON ALL TABLES IN SCHEMA [schema] TO alation;

Query History

See A.7 Postgres QLI Setup for details.