allowing connections from additional hosts without a restart?

Поиск
Список
Период
Сортировка
От Lonni J Friedman
Тема allowing connections from additional hosts without a restart?
Дата
Msg-id 7c1574a905011308555f9e21f3@mail.gmail.com
обсуждение исходный текст
Ответы Re: allowing connections from additional hosts without a restart?  (Peter Eisentraut <peter_e@gmx.net>)
Re: allowing connections from additional hosts without a restart?  (Michael Fuhr <mike@fuhr.org>)
Re: allowing connections from additional hosts without a restart?  ("Frank D. Engel, Jr." <fde101@fjrhome.net>)
Re: allowing connections from additional hosts without a restart?  ("Woody Woodring" <george.woodring@iglass.net>)
Re: allowing connections from additional hosts without a restart?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: allowing connections from additional hosts without a restart?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-general
Дерево обсуждения 
Greetings,
Is it possible to allow TCP/IP connections from additional hosts (IPs)
without restarting postgresql?

The issue i'm having is that i've got a postgresql-7.4.6 box that has
a DB running on it for a j2ee based application on a separate server.
Now i need to add an additional DB for a different server, but I can't
afford any down time to restart postgresql for the changes in
pg_hba.conf to take effect.

Is there any workaround that doesn't require a restart?

thanks!

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       http://netllama.linux-sxs.org

В списке pgsql-general по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: Optimistic concurrency control
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Réf. : Re: Réf. : Debugging SPI Cfunctions