From: ivan marchesini <marchesini@unipg.it>
To: A. Kretschmer <andreas.kretschmer@schollglas.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: could not connect to server
Date: Fri, 13 Oct 2006 11:01:59 +0200
Message-ID: <1160730120.5182.34.camel@geoivan> (raw)
In-Reply-To: <20061013072701.GD27503@a-kretschmer.de>
References: <1160722339.5182.7.camel@geoivan>
<20061013072701.GD27503@a-kretschmer.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: marchesini@unipg.it, andreas.kretschmer@schollglas.com
Subject: Re: could not connect to server
In-Reply-To: <1160730120.5182.34.camel@geoivan>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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