db

Here is the brief step to setup the postgresql database on Ubuntu. Install sudo apt install postgresql postgresql-contrib sudo systemctl start postgresql.service Using postgres Roles and Database A default user account postgres is associated with role. sudo -i -u postgres psql postgres=# \q Create new role createuser --interactive or