Here’s some post install tasks tht should be considered to ensure your PostgreSQL setup is nice and secure.
Install PostgreSQL
sudo apt-get update sudo apt-get install postgresql postgresql-contrib
Upon installation, Postgres creates a Linux user called “postgres” which can be used to access the system. We can change to this user by typing: sudo su - postgres From here, we can connect to the system by typing: psql