DB setting in app.yml are as below:
env:
DISCOURSE_DB_USERNAME: discourse
DISCOURSE_DB_PASSWORD: “XXX”
DISCOURSE_DB_HOST: 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;