Re: Database issues when adding GUI

Поиск
Список
Период
Сортировка
От Sam Gendler
Тема Re: Database issues when adding GUI
Дата
Msg-id CAEV0TzACTfLQe5QQAwW29xd6d+dczBU6aS8d_j-+bXr2mQbfgg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Database issues when adding GUI  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Ответы Re: Database issues when adding GUI  (Rich Shepard <rshepard@appl-ecosys.com>)
Список 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 по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Database issues when adding GUI
Следующее
От: Sam Gendler
Дата:
Сообщение: Re: Need to omit time during weekends from age calculations