Re: Database issues when adding GUI

On Mon, 2021-06-07 at 09:03 -0700, Rich Shepard wrote:
> The problem source is postgres telling me it cannot connect to the database
> but I can do so directly using psql:
>
> $ psql --host salmo --user rshepard --dbname bustrac
> psql: error: could not connect to server: could not connect to server:
> Connection refused
>         Is the server running on host "salmo" (127.0.1.1) and accepting
>         TCP/IP connections on port 5432?

>
> yet,
>
> $ psql bustrac
> psql (12.2)
> Type "help" for help.
>
> bustrac=#
>
> I'm thoroughly confused not before encountering this issue.

If you don't specify a host name, psql/libpq connects using the UNIX domain
socket in /tmp. If you do specify a host name it connects using a TCP socket.
Your PostgreSQL doesn't seem to be listening on TCP, or possibly you have a
firewall issue.