Re: could not connect to server - Mailing list pgsql-sql

From ivan marchesini
Subject Re: could not connect to server
Date
Msg-id 1160730120.5182.34.camel@geoivan
Whole thread Raw
In response to Re: could not connect to server  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: could not connect to server
List pgsql-sql
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





pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: could not connect to server
Next
From: "A. Kretschmer"
Date:
Subject: Re: could not connect to server