View Single Post

   
  #4 (permalink)  
Old 04-08-2008, 06:50 PM
Lonni J Friedman
 
Posts: n/a
Default Re: allowing connections from additional hosts without a restart?

Thanks to all who responded. That works perfectly.


On Thu, 13 Jan 2005 19:28:02 +0100, Peter Eisentraut <peter_e@gmx.net> wrote:
> Lonni J Friedman wrote:
> > 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.

>
> pg_ctl reload or (equivalently) kill -HUP



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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply With Quote