Customer unable to connect on port 5432, Postgres 10.7

Поиск
Список
Период
Сортировка
От Keith Christian
Тема Customer unable to connect on port 5432, Postgres 10.7
Дата
Msg-id CAFWoy7H6FFW4z2pTG8_=-97XqvHNuy4CWqE+Nd=Q6sETUb-uzg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Customer unable to connect on port 5432, Postgres 10.7  (Ron <ronljohnsonjr@gmail.com>)
Re: Customer unable to connect on port 5432, Postgres 10.7  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hello again Postgres friends,

Customer is unable to log in to a PG database on 5432 using a Windows client.
Output of my test sessions below, I think the problem may be lines 3 -
7 but no idea.
Ideas greatly appreciated!


Lines 1,2 PG Log entries
Lines 3-7 pg_hba.conf entries
Lines 8-10 postgresql.conf entries
Lines 11-12 Logging into the postgresql machine from a Linux machine
Lines 13-15 Successfully logged in, testing that SSH to the
linuxserver is successful
Lines 16-20 pguser successfully executes a query

     1. LOG:  connection received: host=aaa.bbb.ccc.ddd port=52310
     2. 2021-01-21 15:34:00.657 MST [12011] FATAL:  no pg_hba.conf
entry for host "aaa.bbb.ccc.ddd", user "pguser", database "testpgdb",
SSL off


     3. # IPv4 local connections:
     4. # host    all             all             127.0.0.1/32          ident
     5. host    pguser        all               eee.fff.ggg.1/24       password
     6. host    pguser        all               hhh.jjj.kkk.1/24        password
     7. host    pguser        all               0.0.0.0/0             password


     8. #listen_addresses = 'localhost'
     9. listen_addresses = '*'
    10. #port = 5432


    11. pguser@linuxserver:~$ ssh -q pguser@www.xxx.yyy.zzz
    12. pguser@www.xxx.yyy.zzz's password:


    13. [pguser@pgserver ~]$ psql -U pguser -W testpgdb
    14. pguser=> \conninfo
    15. You are connected to database "testpgdb" as user "pguser" via
socket in "/var/run/postgresql" at port "5432".


    16. pguser=> select 5.0/99;
    17.         ?column?
    18. ------------------------
    19.  0.05050505050505050505
    20. (1 row)



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

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: interval data type
Следующее
От: Ron
Дата:
Сообщение: Re: Customer unable to connect on port 5432, Postgres 10.7