====== PostgreSQL ======

Update server for latest versions & install PostgreSQL
<sxh>
sudo apt update
sudo apt full-upgrade
sudo apt install postgresql
</sxh>
Add user for openhab
<sxh>
> sudo su postgres
> createuser openhab -P --interactive
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) y
</sxh>
Create DB
<sxh>
> psql
psql (13.13 (Debian 13.13-0+deb11u1))
Type "help" for help.

postgres=# CREATE DATABASE openhab;
CREATE DATABASE
postgres=# exit
</sxh>