Solution for Bucharest
Bucharest - url for task: https://sadservers.com/scenario/bucharest File edit:
If we run command:
PGPASSWORD=app1user psql -h 127.0.0.1 -d app1 -U app1user -c '\q'
We could see issue with access and file named "pg_hba.conf " If we open file, and we could see next lines:
host all all all reject
host all all all reject
If we dig manual for file - we could find that "reject" do that - reject any connection. So replacing with md5 word reject (use sudo for editing file and restarting services), and restart services with
sudo systemctl restart postgresql@13-main.service