Re: tcpip_socket vs -i

Hey, that did insult my intellegence! :) I did get it working without the
"-i" but it seems you cannot do this "on the fly" via pg_ctl reload, that
you have to at least do a restart (either via pg_ctl or stop/start of
postmaster) to get this going. Note this is contrary to something like
turning on debugging output, which can be done via reload. It's a suttle
difference, but one that probably should be mentioned in the docs somewhere.

Robert

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Tom Lane
> Sent: Sunday, February 24, 2002 5:31 PM
> To: Robert Treat
> Cc: Pgsql-General(at)Postgresql(dot) Org
> Subject: Re: [GENERAL] tcpip_socket vs -i
>
>
> "Robert Treat" <robertt(at)auctionsolutions(dot)com> writes:
> > 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.
>
> Works fine for me. Are you sure the postmaster is looking at the same
> postgresql.conf that you think it's looking at?
>
> Or ... not to insult your intelligence, but ... did you remove the '#'
> comment marker from the line that sets tcpip_socket?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>