Обсуждение: could not connect to server
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
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
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
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
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