Re: could not connect to server

From: ivan marchesini <marchesini(at)unipg(dot)it>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: could not connect to server
Date: 2006-10-13 09:01:59
Message-ID: 1160730120.5182.34.camel@geoivan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)unipg(dot)it
ivan(dot)marchesini(at)gmail(dot)com
tel: +39(0)755853760
fax: +39(0)755853756
jabber: geoivan73(at)jabber(dot)org

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2006-10-13 09:18:20 Re: could not connect to server
Previous Message A. Kretschmer 2006-10-13 07:27:01 Re: could not connect to server