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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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