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

Re: PostgreSQL 8.3.7 Clint to Server Connection Problem!

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.3.7 Clint to Server Connection Problem!
Date: 2009-04-14 05:14:19
Message-ID: 20090414051419.GB11459@a-kretschmer.de (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: Just E. MailDate: 2009-04-14 12:04:08
Subject: Re: PostgreSQL 8.3.7 Clint to Server Connection Problem!
Previous:From: A. KretschmerDate: 2009-04-14 05:02:07
Subject: Re: PostgreSQL 8.3.7 Clint to Server Connection Problem

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