Re: Accessing Postgres Server and database from other Machine - Mailing list pgsql-general

From Paul Förster
Subject Re: Accessing Postgres Server and database from other Machine
Date
Msg-id 9BA257B9-D281-4CD0-B8EB-62ABFFD9924B@gmail.com
Whole thread Raw
In response to Re: Accessing Postgres Server and database from other Machine  (Hemil Ruparel <hemilruparel2002@gmail.com>)
Responses Re: Accessing Postgres Server and database from other Machine
Re: Accessing Postgres Server and database from other Machine
List pgsql-general
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.

Cheers,
Paul


pgsql-general by date:

Previous
From: "Muthukumar.GK"
Date:
Subject: Re: Accessing Postgres Server and database from other Machine
Next
From: charles meng
Date:
Subject: Re: Alter the column data type of the large data volume table.