pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedcould not connect to server
5+ messages / 3 participants
[nested] [flat]
* could not connect to server
@ 2006-10-13 06:52 ivan marchesini <marchesini@unipg.it>
2006-10-13 07:27 ` Re: could not connect to server A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-10-13 14:07 ` Re: could not connect to server Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 5+ messages in thread
From: ivan marchesini @ 2006-10-13 06:52 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: could not connect to server
2006-10-13 06:52 could not connect to server ivan marchesini <marchesini@unipg.it>
@ 2006-10-13 07:27 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-10-13 09:01 ` Re: could not connect to server ivan marchesini <marchesini@unipg.it>
1 sibling, 1 reply; 5+ messages in thread
From: A. Kretschmer @ 2006-10-13 07:27 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: could not connect to server
2006-10-13 06:52 could not connect to server ivan marchesini <marchesini@unipg.it>
2006-10-13 07:27 ` Re: could not connect to server A. Kretschmer <andreas.kretschmer@schollglas.com>
@ 2006-10-13 09:01 ` ivan marchesini <marchesini@unipg.it>
2006-10-13 09:18 ` Re: could not connect to server A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 1 reply; 5+ messages in thread
From: ivan marchesini @ 2006-10-13 09:01 UTC (permalink / raw)
To: A. Kretschmer <andreas.kretschmer@schollglas.com>; +Cc: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: could not connect to server
2006-10-13 06:52 could not connect to server ivan marchesini <marchesini@unipg.it>
2006-10-13 07:27 ` Re: could not connect to server A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-10-13 09:01 ` Re: could not connect to server ivan marchesini <marchesini@unipg.it>
@ 2006-10-13 09:18 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 0 replies; 5+ messages in thread
From: A. Kretschmer @ 2006-10-13 09:18 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: could not connect to server
2006-10-13 06:52 could not connect to server ivan marchesini <marchesini@unipg.it>
@ 2006-10-13 14:07 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2006-10-13 14:07 UTC (permalink / raw)
To: marchesini@unipg.it; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-10-13 14:07 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-13 06:52 could not connect to server ivan marchesini <marchesini@unipg.it>
2006-10-13 07:27 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-10-13 09:01 ` ivan marchesini <marchesini@unipg.it>
2006-10-13 09:18 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-10-13 14:07 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox