Postgres
Instructions for connecting a postgres database to AirOps.
Important
Remember to allowlist our IP Address
52.71.87.39
If your database is protected by a firewall, remember to allow inbound access to AirOPs IPS address over your database port.
To set up a new database connection, go to ⚙️ Settings —> Warehouse Setup —> Add Source +

Add the following details:
- Host - The hostname or IP address of your PostgreSQL server.
- Example:
example-postgres-instance.abcdefghijkl.us-west-2.rds.amazonaws.com
- Example:
- Port - The port on which your PostgreSQL server is listening. Default is
5432
. - User - The PostgreSQL user that AirOps will connect to the database with. It is best practice to create a new user for AirOps (instructions below), but any user with SELECT privileges can be used.
- Password - Password for the above user.
- Database - The PostgreSQL database that AirOps will connect to.
Setup user and grant access
In order to add a PostgreSQL database as a Data Source on AirOps, we recommend using an existing user, or creating a user with read access to the tables and schemas you would like to access from AirOps.
If you're creating a new user, you can follow the below instructions:
1. Create AirOps user
CREATE USER airops_user
WITH PASSWORD '<secure-password>';
2. Grant USAGE and SELECT privileges to AirOps user
Replace and
with the appropriate schema and table names that you would like AirOps to interact with.GRANT USAGE ON SCHEMA "<schema>" TO airops_user;
GRANT SELECT ON TABLE "<schema>"."<table>" TO airops_user;
If you want to grant access to multiple tables, you can run the GRANT SELECT
statement for each table or run GRANT SELECT ON ALL TABLES
.
3. (Optional) Grant access to future tables in the schema
If you want to grant access to all future tables in a schema, you can use the following command. Replace with the appropriate schema name.
ALTER DEFAULT PRIVILEGES IN SCHEMA "<schema>"
GRANT SELECT ON TABLES TO airops_user;
Updated about 1 month ago