Re: pg_hba.conf changes without restarting postmaster
От | Christopher Browne |
---|---|
Тема | Re: pg_hba.conf changes without restarting postmaster |
Дата | |
Msg-id | m3u0vpoucy.fsf@wolfe.cbbrowne.com обсуждение исходный текст |
Ответ на | pg_hba.conf changes without restarting postmaster (Si Chen <schen@graciousstyle.com>) |
Список | pgsql-general |
After a long battle with technology, schen@graciousstyle.com (Si Chen), an earthling, wrote: > It seems that every time I make a change to pg_hba.conf, I have to > restart the database server for the new authentication to take effect. > Is there a way to have the server use the new pg_hba.conf > authentication without restarting the production server. You NEVER need to restart the database server to reflect pg_hba.conf changes. The command "pg_ctl -D $PGDATA reload" will cause the server to reload the contents of pg_hba.conf, assuming PGDATA is appropriately set. Several other methods are possible, all of which ultimately amount to sending the signal SIGHUP to the postmaster. -- (format nil "~S@~S" "cbbrowne" "ntlug.org") http://www3.sympatico.ca/cbbrowne/linux.html I found out why cats drink out of the toilet. My mother told me it's because it's cold in there. And I'm like: How did my mother know THAT? --Wendy Liebman
В списке pgsql-general по дате отправления: