How to setup PostgreSQL on Ubuntu server

first ensure ubuntu is updated with latest packages

sudo apt update
sudo apt upgrade -y

Once this is done, you are ready.

Install postgres

sudo apt install postgresql postgresql-contrib -y

# check installation status
sudo systemctl status postgresql

# connect to psql
sudo -u postgres psql

# sudo systemctl status postgresql
ALTER USER postgres PASSWORD 'YourSecurePassword';
# exit
\q