Skip site navigation (1) Skip section navigation (2)

PostgreSQL 8.3.7 Clint to Server Connection Problem!

From: "Just E(dot) Mail" <justemail(at)imwell-usa(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: PostgreSQL 8.3.7 Clint to Server Connection Problem!
Date: 2009-04-13 14:56:43
Message-ID: 49E352AB.30306@imwell-usa.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hello:

Note: English 2nd language, so forgive errors in English.
====

CentOS 5.2

-------------------------
PostgreSQL Server (eth1: 10.43.48.101). The following modules are 
installed:

postghresql-libs-8.3.7, postgresql-8.3.7, postgresql-server-8.3.7, 
pgAdmin3-1.8.4

"postgresql.conf":
     listen_addresses    =    '*
"pg_hba.conf"
    host   all   all   10.43.48.0/16
   
"/etc/services"
    postgresql         5432/tcp
    postgresql         5432/udp
-------------------------

PostgreSQL Client (eth1: 10.43.48.1). The following modules are installed:

postghresql-libs-8.3.7, postgresql-8.3.7 & pgAdmin3-1.8.4

"postgresql.conf" & "pg_hba.conf" has no entry in the PostgreSQL Client.

-------------------------

On the PostgreSQL Server (IP: 10.43.48.101), I can connect to the 
PostgreSQL & create a "Server" listening on port "5432" using "pgAdmin3".

PROBLEM:

When trying to connect to the PostgreSQL Server from PostgreSQL Client, 
get an error message:

"Could not connect to the server: No route to the host Is the server 
running
on host "10.43.48.101" and accepting TCP/IP connections on 5432?"

First of all, I can ping the PostgreSQL server from the Client machine.  
I have researched the Internet and found lots of reference to this error 
but nothing helped.

1. Am I installing all the necessary modules/files on the PostgreSQL 
Client machine?
2. Any suggestion, help?

Sam

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2009-04-13 15:57:19
Subject: Re: PostgreSQL 8.3.7 Clint to Server Connection Problem!
Previous:From: Just E. MailDate: 2009-04-13 14:17:51
Subject: PostgreSQL 8.3.7 Clint to Server Connection Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group