# PostgreSQL

## Supported Hosting Solutions

{% content-ref url="postgres/aws-rds" %}
[aws-rds](https://docs.selectstar.com/integrations/postgres/aws-rds)
{% endcontent-ref %}

{% content-ref url="postgres/aws-aurora" %}
[aws-aurora](https://docs.selectstar.com/integrations/postgres/aws-aurora)
{% endcontent-ref %}

{% content-ref url="postgres/on-prem" %}
[on-prem](https://docs.selectstar.com/integrations/postgres/on-prem)
{% endcontent-ref %}

## Additional Information

#### Sync New Data Assets

If you create a new PostgreSQL schema in your database, we need you to re-grant our permissions.

To sync your new assets into Select Star, follow these steps:

1\. GRANT us access to the new Schema:

```sql
GRANT USAGE ON SCHEMA <schema_name> TO selectstar;
ALTER DEFAULT PRIVILEGES GRANT USAGE ON SCHEMAS TO selectstar;
```

2\. Go to **Select Star > Settings > Data**

3\. Find your Data Source, and click on **Configure**

4\. Click **Refresh**

5\. Click Next, and make sure your new Schema is selected.

![](https://github.com/selectstar/docs-customer/blob/main/integrations/.gitbook/assets/image%20\(7\)%20\(2\).png) ![](https://github.com/selectstar/docs-customer/blob/main/integrations/.gitbook/assets/image%20\(1\)%20\(1\)%20\(3\)%20\(1\).png)

We are always happy to help if you have any other questions! [Send us an email](mailto:support@getselectstar.com).