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: (view raw or whole thread)
Lists: pgsql-jdbc
I added the line [host    all     all   
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


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 trust
> host    all     all         trust
> have you tried "psql gec_test bergeron.melanie" ? what is the output ?
> reading the tutorial there might just help, also : 
> .

In response to


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-2015 The PostgreSQL Global Development Group