PostgreSQL Setup

• Reference URL: https://linuxize.com/post/how-to-install-postgresql-on-debian-10/

• $ sudo -u postgres psql to get into postgress client.

• =# CREATE USER sonardbuser;

• =# ALTER USER omsuser WITH PASSWORD 'new_password';

• =# CREATE DATABASE sonardb WITH TEMPLATE = template0 ENCODING 'UTF8';

• =# exit;

• From client connect with $ psql -h <hostname> -d <db instance name> -U <username>. It will then prompt you for the password.