I make the changes into the pg_hba.conf and do a kill -HUP 'PID' for postgres to reread the file. The pid number can be found in the ~postgres/data/postmaster.pid file Woody IGLASS Networks www.iglass.net -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Lonni J Friedman Sent: Thursday, January 13, 2005 11:55 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: allowing connections from additional hosts without a restart? 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@xxxxxxxxx LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
