Hello,
After searching various threads here on how to get Posgresql running, I am still having no luck

As root or using sudo to service postgresql start the command seems to execute and then I am back in my shell prompt.

Some articles said to run ss -ant to see if postgres is listening, but no reply. I tried ss -lntp | grep port expecting to see the ports listening but no joy.

I did a apt-get dist-upgrade and rebooted and tried again, no joy.

Tried logging in to msfconsole to see this:
~$ sudo msfconsole
[-] Failed to connect to the database: could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?

then: msf > db_status[*] postgresql selected, no connection

then:
msf > db_connect postgresql
msf > db_status[*] postgresql selected, no connection

I tried also connecting pointing to the database.yml file to no end.

Where did I go wrong?
Thanks!