Ubuntu Postgresql

PostgreSQL

Sometimes, SQLite is not enough and we will need a more advanced tool called PostgreSQL, an open-source robust and production-ready database system.

Let's install it now.

Run the following commands:

sudo apt install -y postgresql postgresql-contrib libpq-dev build-essential

sudo -u postgres psql --command "CREATE ROLE \"`whoami`\" LOGIN createdb superuser;"