Postgres Pro
Downloads
Home   >   mailing lists

allowing connections from additional hosts without a restart? - Mailing list pgsql-general

From Lonni J Friedman
Subject allowing connections from additional hosts without a restart?
Date
Msg-id 7c1574a905011308555f9e21f3@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Optimistic concurrency control
Next
From: Tom Lane
Date:
Subject: Re: Réf. : Re: Réf. : Debugging SPI Cfunctions