Re: Accessing Postgres Server and database from other Machine

Поиск
Список
Период
Сортировка
От Paul Förster
Тема Re: Accessing Postgres Server and database from other Machine
Дата
Msg-id 9BA257B9-D281-4CD0-B8EB-62ABFFD9924B@gmail.com
обсуждение исходный текст
Ответ на Re: Accessing Postgres Server and database from other Machine  (Hemil Ruparel <hemilruparel2002@gmail.com>)
Ответы Re: Accessing Postgres Server and database from other Machine
Re: Accessing Postgres Server and database from other Machine
Список 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 по дате отправления:

Предыдущее
От: "Muthukumar.GK"
Дата:
Сообщение: Re: Accessing Postgres Server and database from other Machine
Следующее
От: charles meng
Дата:
Сообщение: Re: Alter the column data type of the large data volume table.