Re: tcpip_socket vs -i

The .conf file is not read automagically as far as I know. You need to restart pg to reread it. So any changes made after starting pg, really have not effect until the next time you restart it.

cheers,
--t.

On Sun, 24 Feb 2002, Robert Treat wrote:

> I'm trying to find out the true behavior of postgres in regards to accepting
> tcpip socket connections. According to the documentation, I should be able
> to start postmaster with just "pg_ctl start" then specify tcpip_socket = on
> (or possibly tcpip_socket = true, I tried both) in postgresql.conf and have
> tcp_ip socket connections working, however after a multitude of different
> attempts I found no way to get tcpip sockets to work unless I started the
> postmaster with -i. I understand that the command line options would
> override the conf file in cases of conflict, but does the mere omission
> of -i override any attempts to use sockets otherwise? I would hope that not
> specifying -i would allow me to turn socket connections on and off via the
> conf file, without a restart of the database, but what is happening in
> practice seems to be going against what is in the docs. Anyone know for
> sure?
>
> Robert Treat
> Auction Management Solutions, Inc.
> Tampa, FL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>