Subject: Re: could not connect to server
From: ivan marchesini <marchesini@unipg.it>
Reply-To: marchesini@unipg.it
To: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <20061013072701.GD27503@a-kretschmer.de>
References: <1160722339.5182.7.camel@geoivan>
	<20061013072701.GD27503@a-kretschmer.de>
Content-Type: text/plain
Organization: University of Perugia
Date: Fri, 13 Oct 2006 11:01:59 +0200
Message-Id: <1160730120.5182.34.camel@geoivan>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

Dear Andreas,
this is my pg_hba.conf file:
______________________________________________________
# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK
METHOD

# IPv4-style local connections:
host    all        all       127.0.0.1       255.255.255.255 trust
host    all        all       "my_netaddres".0       255.255.255.0 trust
#host    all       

# IPv6-style local connections:
#host    all         all         ::1
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust

# Using sockets credentials for improved security. Not available
everywhere,
# but works on Linux, *BSD (and probably some others)

local  all    all             ident   sameuser
__________________________________________________________


I hope is correct...
what do you think??

thank you!!


On ven, 2006-10-13 at 09:27 +0200, A. Kretschmer wrote:
> 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
-- 
Ivan Marchesini
Department of Civil and Environmental Engineering
University of Perugia
Via G. Duranti 93/a 
06125
Perugia (Italy)
e-mail: marchesini@unipg.it
        ivan.marchesini@gmail.com
tel: +39(0)755853760
fax: +39(0)755853756
jabber: geoivan73@jabber.org