Skip site navigation (1) Skip section navigation (2)

Re: problem to connect to database

From: Melanie Bergeron <mbergeron_pg(at)globeecom(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: problem to connect to database
Date: 2004-01-16 18:13:21
Message-ID: 400829C1.7040202@globeecom.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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
>
>
>
> .
>



In response to

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2004-01-16 18:47:16
Subject: Re: problem to connect to database
Previous:From: ACFUtingaDate: 2004-01-16 17:05:11
Subject: Ajuda!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group