I wanted to create a pgsql DB, but I got an error, when I want to save it:
Error: Connection to localhost failed
The postgresql is running, and I can create MySQL DB from HestiaCP.
I can created the db by ssh, but I want to check it too. I can reach the /phppgadmin/ sites too, and can login.
pg_hba.conf:
“local” is for Unix domain socket connections only
local all all md5
IPv4 local connections:
host all all 127.0.0.1/32 md5
IPv6 local connections:
host all all ::1/128 md5
Others
host all all 0.0.0.0/0 md5
postgresql.conf:
listen_addresses = ‘*’
Any idea for this error?