Postgres Pro
Downloads
Home   >   mailing lists

problem with access database - Mailing list pgadmin-support

From Marie-Claude QUIDOZ
Subject problem with access database
Date
Msg-id AE1706B5C143C44589513A92F5945DB76736A1@ZZML.newcefe.newage.fr
Whole thread Raw
In response to Re: slowness in the connection  (Guillaume Lelarge <guillaume@lelarge.info>)
Responses Re: problem with access database  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
Tree view 
Hello

I use 1.12.0 PGAdminIII from a client for seven windows connect to a postgres server 8.4.2.1 installed on a Windows
2008server 32-bit server (service pack 2).  

I want to give access at the database "PicSaintLoup" to user "rihouet"

---------------------

If I configure pg_hba.conf with this line

"host    PicSaintLoup    rihouet        193.49.134.96/32    md5"

I obtain this message
" Error connecting to the server : Fatal : Aucune entrée dans pg_hab.conf pour l'hote "193.49.134.96", utilisateur
"rihouet",base de données "postgres", SSL inactif" 

---------------------

If I configure pg_hba.conf with this line

"host    postgres, PicSaintLoup    rihouet        193.49.134.96/32    md5"

It is ok

--------------------

I don't understand why I must make "postgres" in this line ?

Thank you

MCQ

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: SQL pane error
Next
From: Andreas
Date:
Subject: pgAdmin 1.12.0 / Win / no drag&drop in SQL-Editor ???