Question

What are the prerequisites to install PostgreSQL on Ubuntu?

Answer 1

Before you start installing postgreSQL, make sure you have the following:

Log in a root user

Create a new user

adduser ​bob

Grant the administrative privileges

usermod -aG sudo bob

Set up firewall

ufw app list
ufw allow OpenSSH
ufw enable