-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
You could always create and configure a new data directory, then start a new instance of the postmaster running on a different port. Use the new instance for the other client. That would separate the user accounts, too...
On Jan 13, 2005, at 11:55 AM, Lonni J Friedman wrote:
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 [EMAIL PROTECTED] 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
- ----------------------------------------------------------- Frank D. Engel, Jr. <[EMAIL PROTECTED]>
$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)
iD8DBQFB5rcQ7aqtWrR9cZoRAmyZAJwNkk/b3QmgmKsoQpfAzdGEmhFjAwCZATtH M77PWcaAyj5imsfPS9nBqXw= =Prxi -----END PGP SIGNATURE-----
___________________________________________________________ $0 Web Hosting with up to 120MB web space, 1000 MB Transfer 10 Personalized POP and Web E-mail Accounts, and much more. Signup at www.doteasy.com
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
