TCP only listening on localhost???

Richard Gass

First weird problem...
The other day, out of the blue, our application reported an error saying it
could not connect to the postgres db. The hostname that it reported is the
name of the machine but it hasn't been used in awhile. However, it does
have a valid cname entry in dns pointing to the correct host. I added the
name in the /etc/hosts file on the server and the problem was fixed.

Next weird problem...
I recently upgraded a few nodes that connect to the server to Redhat 9. I
installed all the necessary rpm's and when I tried to connect to the remote
server, I get the following error.

# psql -U postgres -d dbname -h server_name
psql: could not connect to server: Connection refused
Is the server running on host server_name and accepting
TCP/IP connections on port 5432?

Here is the output of netstat -ae | grep tcp | grep LIST

....
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN

tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN

tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN

tcp 0 0 0.0.0.0:443 0.0.0.0:* LISTEN

....

As you can see, postgres is listening on localhost put not "0.0.0.0:54 32" as
I see in many posts to this site. This was working fine before but now I
cannot connect from any other server that I have given permission to in
pg_hba.conf.
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 10.64.228.10 255.255.255.255 trust
host all all 10.64.228.112 255.255.255.255 trust
host all all 10.64.228.115 255.255.255.255 trust

And Yes I have the "-i" option specified in my postmaster command...
/usr/local/db/pgsql/bin/postmaster -i -c log_connections =on -h server_name
-D /usr/local/db/pgsql/data

and Yes I have tcpip_socket = true in postgresql.conf .

No, I do not have multiple installs of postgres on this system and I am sure
they are using the correct configuration files.

This was all working fine until I recently. It has been a long time since I
have restarted the server ( 5:05pm up 377 days, 18:36, 7 users, load
average: 0.00, 0.00, 0.00) and it has been a long time since I restarted the
postgres DB. I wonder if some weirdness is happening which isn't allowing
postgres to bind to tcp port 5432.

From the server... This is connecting through the socket...
# psql -h server_name -U postgres -d dbname
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

dbname=# \q
From the server... This is trying to connect to the port...
# psql -h 10.64.228.10 -U postgres -d dbname
psql: could not connect to server: Connection refused
Is the server running on host 10.64.228.10 and accepting
TCP/IP connections on port 5432?

Any ideas what could be happening?

Thanks

Richard
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #1

Subscribe Reply

2379

Similar topics

2723

Listening socket not seen outside of localhost

by: Christian von Essen | last post by:

Hi, As I don't know if my problem is python, platform or non-specific, I try to post my question here, as you may have made similar experiences. I try to write a simple chatserver, using the socket module. Everything works fine, as long as I'm trying to connect to the server from the host, the server is running. If I try to access the server from another computer in my local network, the connection is refused.

Python

2012

Listening socket problem

by: Laszlo Csabi | last post by:

Hi guys, What I would like to achieve is create a client-server messenger application. The problem I run into is : I have created a listener socket on the client and connect to the remote server ( with a another socket ) to login also tell the server what IP and PORT address the client is listening on, but the IP address an internal IP and not my public IP address because I'm behind a router. Is there any way I could connect to the...

.NET Framework

17096

Connectivity issue - SQLServer not listening on port 1433/ms-sql-s

by: Akif | last post by:

Hi. I'm a SQL Server novice, so apologies if any of this sounds simple. I am running Windows XP SP2, and have just installed SQLServer 2000. I need another application to connect to SQLServer, and am specifying it to do so via localhost:1433, but keep getting an error whenever I try doing so saying it cannot connect to the database. A colleague of mine has the exact same set up on his machine, and he can connect to SQL Server fine....

Microsoft SQL Server

2012

Listening for messages in compact.net

by: Adam | last post by:

Hi, How do i listen for windows messages in c# on compact.net? I have a window containing an instantiation of the HTML viewer control, which is a child of the main form. As the compact implementation of the form class does not have a wndproc function to override, i cannot get the messages. I cannot use a message window, as the window i am listening to will then not display. Is there another method of doing this?

C# / C Sharp

2153

Listening on Ports

by: Xarky | last post by:

Hi, I am writing a small web server, to listen on web browser port(8080), if I'm not wrong. Basically for parsing some tags found in html. Now I am doing as follows TcpListener mainTcp = new TcpListener(8080); mainTcp.Start();

C# / C Sharp

3129

faild to start listening port 1034

by: kai | last post by:

Hi, I was tring to run an example (HelloWorld.aspx) from MSPrss book, I get this message: "ASP.NET Development Server faild to start listening port 1034. Error message: An attempt was made to access a socket in a way fobidden by its access permissions."