Re: problem to connect to database - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: problem to connect to database
Date
Msg-id 1074278836.1602.117.camel@localhost.localdomain
Whole thread Raw
In response to Re: problem to connect to database  (Melanie Bergeron <mbergeron_pg@globeecom.com>)
Responses Re: problem to connect to database
List pgsql-jdbc
Melanie,

If you can't telnet into it, then the driver won't connect either.

If you use windows just run telnet with no args
a box will come up and you can enter the port, and host

it should connect and nothing else.

If it doesn't then it is a network problem

Dave
On Fri, 2004-01-16 at 13:13, Melanie Bergeron wrote:
> I added the line [host    all     all     10.0.0.0   255.255.255.0
> trust] in my pg_hba.conf (the other line was already there) but no results.
> I will take a look to the tutorial, maybe I will find my problem.  But I
> still can't figured out why it worked last week and not today.
>
> Thanks to all for your replies
>
> Melanie
>
> Erwan Arzur wrote:
>
> > Dave wanted you to check just that, but used a syntax that just
> > doesn't work on the platform you're using (did you see that it's
> > trying to resolve host:5432 ?). Telnet connects you to the TCP port
> > you specify on the command line, and 'man telnet' is your friend, by
> > the way ...
> >
> >
> > The output of netstat just means your server is started and listening
> > on port 5432, so that's one problem solved.
> >
> > Now that means you have to investigate some other problems. Supposing
> > you're using postgres on a linux box, your database may be in
> > /var/lib/pgsql/data. Is the pg_hba.conf file there correctly setup to
> > allow connections from the webserver ?
> >
> > You need something like this (not recommended on production
> > environments) :
> >
> > host    all     all     127.0.0.1       255.255.255.255 trust
> > host    all     all     10.0.0.0                255.255.255.0   trust
> >
> > have you tried "psql gec_test bergeron.melanie" ? what is the output ?
> >
> > reading the tutorial there might just help, also :
> > http://www.postgresql.org/docs/current/static/tutorial.html
> >
> >
> >
> > .
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
--
Dave Cramer
519 939 0336
ICQ # 1467551


pgsql-jdbc by date:

Previous
From: Melanie Bergeron
Date:
Subject: Re: problem to connect to database
Next
From: Melanie Bergeron
Date:
Subject: Re: problem to connect to database