> On 5 Dec 2020, at 10:05, Paul Förster <paul.foerster@xxxxxxxxx> wrote: > > Hi Hemil, > >> On 05. Dec, 2020, at 07:50, Hemil Ruparel <hemilruparel2002@xxxxxxxxx> wrote: >> >> Did you restart postgres after changing pg_hba.conf? > > that shouldn't be necessary for changes in pg_hba.conf. Just do either on the command line: > > $ pg_ctl reload While you’re in there, also verify that something is listening on the port (see below) $ netstat -an > or from psql: > > postgres=# select pg_reload_conf(); > > You can then see the effective result immediately in pg_hab_file_rules: > > postgres=# table pg_hba_file_rules; Also: postgres=# show listen_addresses; postgres=# show port; Those will tell you whether the server is listening on the network and on the expected port. Alban Hertroys -- There is always an exception to always.
