Re: PostgreSQL 8.3.7 Clint to Server Connection Problem!

In response to Just E. Mail :
> 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

Wrong entry, i'm missing the AUTH-Method.

>
> 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?"

Apparently a network-issue.

>
> First of all, I can ping the PostgreSQL server from the Client machine.

Sure? Maybe a firewall-issue. Show us the output generated with:

iptables -L

from the server.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net