On Mon, Jun 7, 2021 at 9:24 AM Alan Hodgson <ahodgson@xxxxxxxxxxxxxxx> 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. Itis localhost.127.0.0.1 localhost.localdomain localhost127.0.1.1 salmo.appl-ecosys.com salmo # for slrnYeah 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.
