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 <mailingl...@unix-solution.de> 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. > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
