Re: Postgresql is not accepting TCP/IP connections.
I restarted after, it wasn't a change in the configuration, postgres
installs default with tcp/ip enabled (or beacuse my old version pinned 7.2
was configured like this).
output of netstat gives:
tcp 0 0 0.0.0.0:10080 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:2401 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:139 0.0.0.0:* LISTEN
tcp 0 0 192.168.2.20:80 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:10005 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:10009 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:445 0.0.0.0:* LISTEN
its apache, samba ports, cvs, email ports, mysql , ssh and tomcat, but not port
5432 for postgres, so its not listening
thanks for the help
hans
On Tue, Feb 03, 2004 at 09:12:14AM -0500, Adam Aube wrote:
> On Tuesday 03 February 2004 08:28 am, Hans Steinraht wrote:
> > The only waht not is working is that I cannot connect to postgresql
> > through TCP/IP.
>
> > In /etc/postgresql.conf I have: tcpip_socket = true, but its not
> > working.
>
> You specified that you restarted postgresql - I assume that you did it
> AFTER making the configuration change. If not, try restarting it again.
>
> Next, try:
>
> $ netstat -a -n | grep "tcp" | grep "LISTEN"
>
> Look for the port postgresql is supposed to listen on to make sure that
> it's really listening.
>
> If postgresql is listening, but you can't connect to it, make sure your
> firewall isn't interfering.
>
> Adam
>
>
> --
> To UNSUBSCRIBE, email to debian-user-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>
--
Reply to: