# Postgres Warehouse Setup

{% hint style="info" %}
Warehouses are only available for users on the Freshpaint business plan.
{% endhint %}

**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:**

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

**2. Once this user has been created, please reach out to <support@freshpaint.io> with the following information about your DB**:

* host
* username
* password
  * can be sent securely through [onetimesecret.com](http://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 <support@freshpaint.io> and we'll take it from here.**

{% hint style="info" %}
**We can also connect through an SSH proxy upon request.**
{% endhint %}