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
Ответ на
Список
Дерево обсуждения
Accessing Postgres Server and database from other Machine "Muthukumar.GK" <muthankumar@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 "Muthukumar.GK" <muthankumar@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 Tim Clarke <tim.clarke@minerva.info>
Re: Accessing Postgres Server and database from other Machine Adrian Klaver <adrian.klaver@aklaver.com>
Re: Accessing Postgres Server and database from other Machine Paul Förster <paul.foerster@gmail.com>
Re: Accessing Postgres Server and database from other Machine Adrian Klaver <adrian.klaver@aklaver.com>
Re: Accessing Postgres Server and database from other Machine Nicklas Avén <nicklas.aven@jordogskog.no>
Re: Accessing Postgres Server and database from other Machine "Muthukumar.GK" <muthankumar@gmail.com>
Re: Accessing Postgres Server and database from other Machine Adrian Klaver <adrian.klaver@aklaver.com>
Re: Accessing Postgres Server and database from other Machine Hemil Ruparel <hemilruparel2002@gmail.com>
Re: Accessing Postgres Server and database from other Machine Paul Förster <paul.foerster@gmail.com>
Re: Accessing Postgres Server and database from other Machine Adrian Klaver <adrian.klaver@aklaver.com>
Re: Accessing Postgres Server and database from other Machine Paul Förster <paul.foerster@gmail.com>
Re: Accessing Postgres Server and database from other Machine Alban Hertroys <haramrae@gmail.com>
Re: Accessing Postgres Server and database from other Machine "Muthukumar.GK" <muthankumar@gmail.com>
Re: Accessing Postgres Server and database from other Machine Hemil Ruparel <hemilruparel2002@gmail.com>
Hi Hemil,

> On 05. Dec, 2020, at 07:50, Hemil Ruparel  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
Дата:
От: charles meng
Дата:
FAQ