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