# External postgres setup not working

**URL:** <https://meta.discourse.org/t/external-postgres-setup-not-working/259657>\
**Category:** Self-hosting\
**Created:** [March 28, 2023, 7:05am UTC](https://meta.discourse.org/t/external-postgres-setup-not-working/259657 "2023-03-28T07:05:57Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![deepak\_b](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@deepak\_b](https://meta.discourse.org/u/deepak_b)\
**Post date:** [March 28, 2023, 4:52pm UTC](https://meta.discourse.org/t/external-postgres-setup-not-working/259657/3 "2023-03-28T16:52:38Z")

</div>

DB setting in app.yml are as below:

env:  
DISCOURSE\_DB\_USERNAME: discourse  
DISCOURSE\_DB\_PASSWORD: “XXX”  
DISCOURSE\_DB\_HOST: [xxx.rds.amazonaws.com](http://xxx.rds.amazonaws.com)  
DISCOURSE\_DB\_NAME: discourse

I am able to connect with this DB using pgAdmin. I have executed below commands in this DB for discourse:

CREATE USER discourse PASSWORD ‘XXX’;  
CREATE DATABASE discourse OWNER discourse;

CREATE EXTENSION hstore;  
CREATE EXTENSION pg\_trgm;

---

_[View the full topic](https://meta.discourse.org/t/external-postgres-setup-not-working/259657)._