PostgreSQL

Instructions for syncing data into Vitally via PostgreSQL

Requirements

Make sure that your PostgreSQL warehouse is accessible over the internet.
Create unique PostgreSQL credentials, using password authentication for Vitally's access to the database and grant the user permission to the required tables.
Safe-list Vitally's IP addresses in any relevant security groups:
- For US-hosted Vitally customers: 52.2.105.119, 34.198.95.164, 54.225.45.200, 3.233.54.92, 44.197.82.135, 44.205.137.47, 3.231.135.245, 34.234.2.125, 18.117.45.34, 18.118.174.158, 3.128.104.4, 3.128.39.40, 3.137.39.224, 3.20.73.62
- For EU-hosted Vitally customers: 13.50.117.250, 13.48.176.93, 13.48.142.17, 13.53.227.107, 16.171.90.148, 16.170.120.57, 16.171.215.121, 16.171.156.82

We'll need these values to connect to your Postgres warehouse:

Host: The public hostname of your Postgres warehouse.
Port: The port number of your Postgres warehouse. By default, it is 5432.
Database: The name of the database that you want to connect to (e.g. production).
Username: A unique user that you've created for Vitally.
Password: That user's password.

Last updated 4 months ago