Re: Accessing Postgres Server and database from other Machine

On 12/5/20 1:05 AM, Paul Förster wrote:
> Hi Hemil,
> 
>> On 05. Dec, 2020, at 07:50, Hemil Ruparel <hemilruparel2002@gmail.com> 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
> 
> 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;
> 
> Hope this helps.

Given that the OP changed pg_hba.conf.sample, probably not:).

> 
> Cheers,
> Paul
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com