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
Next up, I'll show you how to do this with LightSail's RDS PaaS DB option.