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

Reply via email to