Re: Database issues when adding GUI

On Mon, Jun 7, 2021 at 9:24 AM Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca>
wrote:

> On Mon, 2021-06-07 at 09:22 -0700, Rich Shepard wrote:
>
>
> salmo, 127.0.0.1 is the server/workstation that has everything installed.
> It
> is localhost.
> 127.0.0.1 localhost.localdomain localhost
> 127.0.1.1 salmo.appl-ecosys.com salmo # for slrn
>
>
> Yeah that's your problem. PostgreSQL isn't going to be listening on
> 127.0.1.1
>
> It still looks a lot like the salmo hostname is going to be a problem once
you have the client version sorted out. Postgresql is listening only on
127.0.0.1:5432 and pg_hba.conf only has entries for 127.0.0.1:5432, not
127.0.1.1 You can tell it to listen on all addresses with * in
listen_addresses, and then just put the appropriate value in pg_hba.conf to
allow connections on the address you will be using for the user you will be
using. That's in addition to the version mismatch problems you seem to be
having.