Re: Database issues when adding GUI

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Database issues when adding GUI
Дата
Msg-id b251ff3cb957cd99269b8951f88864843d052df1.camel@lists.simkin.ca
обсуждение исходный текст
Ответ на Re: Database issues when adding GUI  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Database issues when adding GUI
Re: Database issues when adding GUI
Список pgsql-general
Дерево обсуждения
On Mon, 2021-06-07 at 09:03 -0700, Rich Shepard wrote:
The problem source is postgres telling me it cannot connect to the database
but I can do so directly using psql:

$ 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?


yet,

$ psql bustrac
psql (12.2)
Type "help" for help.

bustrac=#

I'm thoroughly confused not before encountering this issue.


If you don't specify a host name, psql/libpq connects using the UNIX domain socket in /tmp. If you do specify a host name it connects using a TCP socket. Your PostgreSQL doesn't seem to be listening on TCP, or possibly you have a firewall issue.

В списке pgsql-general по дате отправления: