I don't know whats wrong there host mydns mydns localhost trust works well and #host all all 0.0.0.0 0.0.0.0 md5 did not work. I use Postgres 9.3.4-1.pgdg70+1. Am 09.07.2014 14:04, schrieb basti: > Here is the output of the echo. > > host=127.0.0.1 user=mydns password=mypass sslmode=allow dbname=mydns > > I have also try host=localhost and sslmode=require > > > Am 09.07.2014 13:47, schrieb Francisco Olarte: >> Hi: >> >> On Wed, Jul 9, 2014 at 1:04 PM, basti <mailinglist@xxxxxxxxxxxxxxxx> wrote: >>> Hello my pg_hab.conf has this entry: >>> host all all 127.0.0.1/32 md5 >> .... >>> global $dbhost, $dbuser, $dbpass, $dbname, $use_pgsql, $dbconn; >> ... >>> $connect = "host=$dbhost user=$dbuser password=$dbpass >>> dbname=$dbname"; >> ... >>> When I try to connect via >>> psql -U user -h localhost -W database >> >> Which is the value of $dbhost ? is it localhost, to be coherent with >> your psql line? ( or the output of the echo you put in the sample >> script? ) >> >> If $dbhost is not localhost a name which resolves to 127.0.0.1 or a >> literal 127.0.0.1 you are not getting in ( if the machine is 3.4.5.6 >> and you connect to machine.name.com which resolves to 3.4.5.6 your >> usually get this kind of problems. >> >> Francisco Olarte. >> > >
