allowing connections from additional hosts without a restart?

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: allowing connections from additional hosts without a restart?
Date: 2005-01-13 16:55:08
Message-ID: 7c1574a905011308555f9e21f3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bsimon 2005-01-13 16:57:33 Réf. : Re: Réf. : Re: Réf. : [ GENERAL] Debugging SPI C functions
Previous Message Karsten Hilbert 2005-01-13 16:44:22 Re: Optimistic concurrency control