Re: allowing connections from additional hosts without a restart?

-----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                                    netllama@gmail.com
> 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.  <fde101@fjrhome.net>

$ 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