Re: Postgresql is not accepting TCP/IP connections.>ITS WORKING

[Oliver Elphick <olly@solport.bray-healthcare.com>]

On Thu, 2004-02-05 at 13:34, Oliver Elphick wrote:
> On Thu, 2004-02-05 at 09:23, Hans Steinraht wrote:
> > Thanks for all the help.
> > 
> > On versions to 7.2 the startup script looked in
> > /etc/postgresql/postgresql.conf for the option
> > tcpip_socket = true to be set and put the -i.
> > 
> > I figured out now that in version 7.4 you have to set the option in
> > postmaster.conf as: POSTMASTER_OPTIONS="-i"

One possible reason why this might be so for you is if
/etc/postgresql/postgresql.conf is not linked to
$PGDATA/postgresql.conf.  PostgreSQL always looks at the latter, which
ought to be a symlink to /etc/postgresql/postgresql.conf .

> No.  (Oh, that will work, but it is the wrong way to do it.  You hardly
> ever need to put anything there.)
> 
> > restarting postgres and all works.....
> > 
> > I'm not sure if postgresql.conf still is used (don't think so).
> 
> Yes it is.  However, you need to send a SIGHUP to the postmaster, or
> restart the postmaster, after changing it.  (Do /etc/init.d/postgresql
> reload .)  You also need suitable authorisation in
> /etc/postgresql/pg_hba.conf for anyone to be able to connect.
> 
> If tcpip_socket is set true, you do not need the -i option as well; they
> are alternative ways of doing the same thing.
> 
> Oliver Elphick
> PostgreSQL maintainer