Postgres Warehouse Setup

Warehouses are only available for users on the Freshpaint business plan.

To get started with warehouse setup, please create a new user for Freshpaint that has create permission for your DB. This can be done with the following script:

CREATE USER freshpaint PASSWORD <password>;
GRANT CREATE ON DATABASE <database> TO freshpaint;

2. Once this user has been created, please reach out to [e-mail] with the following information about your DB:

• host

• username

• password

  • can be sent securely through onetimesecret.com

• database name

3. Additionally, please make sure your DB is publicly addressable, and then whitelist the following IPs:

• 44.229.168.72/32

• 35.227.135.0/29

• 35.234.176.144/29

• 52.0.2.4/32

Once this is completed, we'll need to finish the setup on our end. Notify [e-mail] and we'll take it from here.

We can also connect through an SSH proxy upon request.