Re: Cannot connect though socket - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: Cannot connect though socket
Date
Msg-id 20060807031356.70527.qmail@web31801.mail.mud.yahoo.com
Whole thread Raw
In response to Re: Cannot connect though socket  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
> > # IPv4 local connections:
> > host    all         all         0.0.0.0 0.0.0.0          password
> > host    all         all         127.0.0.1/32          trust
> >
> > Well, although I can connect using psql from a command line, the same
> > cannot be said by a jdbc connection or a pgadmin3 interface. I've
> > checked postgres.conf and it has the port=5432 uncommented (isn't this
> > enough to allow socket connections?).

Also I would check that the postmaster is started with the -i option.
http://www.postgresql.org/docs/8.1/interactive/app-postmaster.html

it allows tcp/ip connections to your server.

Also,  I am not sure if your IP/net mask specified will allow you to connect from a remote
computer. I would try setting this to a different value.  <your client ip> <255.255.255.0> allow
all ip within that sub-net.

Regards,

Richard Broersma Jr.

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Cannot connect though socket
Next
From: Tom Lane
Date:
Subject: Re: Cannot connect though socket