Re: Database issues when adding GUI - Mailing list pgsql-general

From Sam Gendler
Subject Re: Database issues when adding GUI
Date
Msg-id CAEV0TzACTfLQe5QQAwW29xd6d+dczBU6aS8d_j-+bXr2mQbfgg@mail.gmail.com
Whole thread Raw
In response to Re: Database issues when adding GUI  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Responses Re: Database issues when adding GUI  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general


On Mon, Jun 7, 2021 at 9:24 AM Alan Hodgson <ahodgson@lists.simkin.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.



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Database issues when adding GUI
Next
From: Sam Gendler
Date:
Subject: Re: Need to omit time during weekends from age calculations