Setting up PostgreSQL in Manjaro

setuppsql.sh

sudo pacman -S postgresql postgis

sudo su postgres -l # or sudo -u postgres -i
initdb --locale $LANG -E UTF8 -D '/var/lib/postgres/data/'
exit

sudo systemctl enable --now postgresql.service

sudo su postgres -c psql
CREATE USER deployer WITH PASSWORD 'eldeployerloco';
ALTER ROLE deployer WITH CREATEDB;
\q