Date: Fri, 13 Oct 2006 09:27:01 +0200
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: could not connect to server
Message-ID: <20061013072701.GD27503@a-kretschmer.de>
References: <1160722339.5182.7.camel@geoivan>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1160722339.5182.7.camel@geoivan>
User-Agent: Mutt/1.5.9i

am  Fri, dem 13.10.2006, um  8:52:19 +0200 mailte ivan marchesini folgendes:
> Dear Users,
> I have this problem:
> I'm running postgres 7.3 on a linux system...

Uhm, a very old version...


> I have started postmaster with -i option, but when I try to connect to
> the server  from another computer I obtain:
> 
> psql: could not connect to server: Nessuna rotta verso l'host
>         Is the server running on host "IP....." and accepting
>         TCP/IP connections on port 5432?
> 
> when I try to connect from the same computer running the postgres server
> (using TCP/IP )
> psql cave_prova -h IP.... -p 5432 -U aurora
> 
> the server answer correctly... and I can connect...
> so I think the TCP/IP socket is working well!!!
> 
> can you suggest me some ideas for solving this problem???
> thank you
> Ivan

Take a look in you ph_hba.conf - file and edit this properly. You need
an entry for the other host.

http://www.postgresql.org/docs/current/static/client-authentication.html


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