| From: | Paul Förster <paul(dot)foerster(at)gmail(dot)com> |
|---|---|
| To: | 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>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "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 09:05:05 |
| Message-ID: | 9BA257B9-D281-4CD0-B8EB-62ABFFD9924B@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
Cheers,
Paul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | charles meng | 2020-12-05 10:38:40 | Re: Alter the column data type of the large data volume table. |
| Previous Message | Muthukumar.GK | 2020-12-05 07:12:04 | Re: Accessing Postgres Server and database from other Machine |