Now it is time to provision our database. We are going to go with Postgres.
There are 2 ways to do this on AWS, we can either install Postgres into our ec2 Linux host, or we can provision the database separately in AWS LightSail as a PaaS RDS database.
In this example we are just going to install Postgres locally on our LightSail ec2 instance.
This is a fairly simple process, first of lets install a recent version of Postgres.
sudo apt install postgresql-11 libpq-dev
Next up we we are going to setup our DB user.
sudo -u postgres createuser lee -s # If you would like to set a password for the user, you can do the following sudo -u postgres psql postgres=# \password lee
That's it for installing and setting up PostGres within an EC2 instances.
rails new mynewrailsapp -d postgresql
Visit http://localhost:3000 to view your new rails app
That should be it, you can then go ahead and create some of your models and migrations and start building your dreams.