allowing connections from additional hosts without a restart?

[Lonni J Friedman]

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]netllama@gmail.com[/email]
LlamaLand [url]http://netllama.linux-sxs.org[/url]

---------------------------(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.]

-----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]netllama@gmail.com[/email]
> LlamaLand [url]http://netllama.linux-sxs.org[/url]
>
> ---------------------------(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 [url]www.doteasy.com[/url]


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

[url]http://archives.postgresql.org[/url]

[Michael Fuhr]

On Thu, Jan 13, 2005 at 08:55:08AM -0800, Lonni J Friedman wrote:

> Is it possible to allow TCP/IP connections from additional hosts (IPs)
> without restarting postgresql?

"pg_ctl reload" should cause the server to re-read its configuration
files without shutting down and restarting. See the section on
pg_ctl in the "PostgreSQL Server Applications" part of the documentation.

--
Michael Fuhr
[url]http://www.fuhr.org/~mfuhr/[/url]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [email]majordomo@postgresql.org[/email]

[Peter Eisentraut]

Lonni J Friedman wrote:

> 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.

pg_ctl reload or (equivalently) kill -HUP

--
Peter Eisentraut
[url]http://developer.postgresql.org/~petere/[/url]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [email]majordomo@postgresql.org[/email]

[Tom Lane]

Lonni J Friedman <netllama@gmail.com> writes:

> 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.

SIGHUP (a/k/a pg_ctl reload) is sufficient for editing pg_hba.conf.

If you'd not had tcpip_socket enabled to start with, you would need a
restart to turn that on, but as long as the socket is there you are
good.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

[url]http://www.postgresql.org/docs/faqs/FAQ.html[/url]

[Woody Woodring]

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
[url]www.iglass.net[/url]

-----Original Message-----
From: [email]pgsql-general-owner@postgresql.org[/email]
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Lonni J Friedman
Sent: Thursday, January 13, 2005 11:55 AM
To: [email]pgsql-general@postgresql.org[/email]
Subject: [GENERAL] 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 [email]netllama@gmail.com[/email]
LlamaLand [url]http://netllama.linux-sxs.org[/url]

---------------------------(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 [email]majordomo@postgresql.org[/email])

[Lonni J Friedman]

Thanks to all who responded. That works perfectly.


On Thu, 13 Jan 2005 19:28:02 +0100, Peter Eisentraut <peter_e@gmx.net> wrote:

> Lonni J Friedman wrote:

> > 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.

>
> pg_ctl reload or (equivalently) kill -HUP

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~
L. Friedman [email]netllama@gmail.com[/email]
LlamaLand [url]http://netllama.linux-sxs.org[/url]

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings