| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Paul Förster <paul(dot)foerster(at)gmail(dot)com>, Hemil Ruparel <hemilruparel2002(at)gmail(dot)com> |
| Cc: | "Muthukumar(dot)GK" <muthankumar(at)gmail(dot)com>, Nicklas Avén <nicklas(dot)aven(at)jordogskog(dot)no>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Accessing Postgres Server and database from other Machine |
| Date: | 2020-12-05 14:58:30 |
| Message-ID: | 2868688b-2344-5d8e-e321-b329b7a61e47@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/5/20 1:05 AM, Paul Förster wrote:
> Hi Hemil,
>
>> On 05. Dec, 2020, at 07:50, Hemil Ruparel <hemilruparel2002(at)gmail(dot)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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Förster | 2020-12-05 15:04:14 | Re: Accessing Postgres Server and database from other Machine |
| Previous Message | Adrian Klaver | 2020-12-05 14:55:46 | Re: Accessing Postgres Server and database from other Machine |