Re: tcpip_socket vs -i

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: Robert Treat <robertt(at)auctionsolutions(dot)com>
Cc: "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: tcpip_socket vs -i
Date: 2002-02-24 22:30:11
Message-ID: Pine.LNX.4.21.0202241718470.7686-100000@antimony.cs.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-02-24 22:31:04 Re: tcpip_socket vs -i
Previous Message Tom Lane 2002-02-24 22:22:35 Re: pg_dump sequence START incorrect?