Re: Database issues when adding GUI

[Alan Hodgson <ahodgson@xxxxxxxxxxxxxxx>]

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.