Re: Database issues when adding GUI

On Mon, 7 Jun 2021, Rob Sargent wrote:

> psql --host machine --user role --dbname something
> For your app it might be a config file with corresponding entries, or perhaps 
> you command line invocation?
> I suspect there's a mis-match between the two.

Rob,

$ 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?
could not connect to server: Connection refused
     Is the server running on host "salmo" (192.168.55.1) and accepting
     TCP/IP connections on port 5432?

Yet, /tmp has .s.PGSQL.5432= and .s.PGSQL.5432.lock

and I can access all databases using psql; e.g., 
$ psql jerrittmine 
psql (12.2)
Type "help" for help.

You're on the right path here. The server is running on salmo (the local
host) and accepting connections on port 5432. At least, that's how I'm
seeing it.

Regards,

Rich