Re: BUG #15284: SSL connection is off

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: chiranjeevi(at)greycampus(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15284: SSL connection is off
Date: 2018-07-19 14:20:22
Message-ID: 20747.1532010022@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)org> writes:
> psql -h 185.168.192.147 -U postgres
> psql: FATAL: no pg_hba.conf entry for host "183.82.105.209", user
> "postgres", database "postgres", SSL off

Hmm. This line:

> host all all 0.0.0.0/0 md5

certainly ought to match that connection attempt. So I can think of
two possibilities:

1. You are not looking at the pg_hba.conf file that the running server
is actually using. "SHOW hba_file" could be used to confirm which one
that is.

2. You modified the file since the server was started, and didn't
SIGHUP the server to tell it to re-read the file. ("pg_ctl reload"
would fix that, or your packager may have provided a wrapper script
for it.)

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-07-19 16:03:05 BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows
Previous Message Quân Vũ Quốc 2018-07-19 08:44:28 Domain: Peer's Certificate has expired