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