Create Postgres Database Reference

I always forget the commands for creating a postgres database from EC2, so I made a reference so that I don't have to figure it out again next year. The main thing that always throws me off is that the createdb command isn't run in the psql command or have a postgresql related command name.

Install postgresql-client


apt-get install postgresql-client

Create Database


createdb database_name -U username -h your_rds_endpoint.us-east-1.rds.amazonaws.com