Thread: could not connect to server

could not connect to server

From
ivan marchesini
Date:
Dear Users,
I have this problem:
I'm running postgres 7.3 on a linux system...
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


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





Re: could not connect to server

From
"A. Kretschmer"
Date:
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


Re: could not connect to server

From
ivan marchesini
Date:
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





Re: could not connect to server

From
"A. Kretschmer"
Date:
am  Fri, dem 13.10.2006, um 11:01:59 +0200 mailte ivan marchesini folgendes:
> 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       

with "my_netaddres" is a valid Ip-Net-Address?
Looks okay, but i have 8.1 and i have something like this:
(CIDR-notation)

host    all         all         192.168.1.0/24          trust


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


Re: could not connect to server

From
Tom Lane
Date:
ivan marchesini <marchesini@unipg.it> writes:
> 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?

Does that translate as "No route to host"?  If so, you've got basic
networking connectivity problems, unrelated to Postgres.  Check
networking parameters, cables firmly attached, etc.  When you can
ping the server from the client, then start trying psql ...
        regards, tom lane