Re: problem to connect to database

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
>
>
>
> .
>