Re: problem with access database

Le 01/10/2010 16:20, Marie-Claude QUIDOZ a écrit :
> 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 2008 server 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 ?
> 

By default, pgAdmin connects to the postgres database. With "by default"
I mean that you didn't change the maintenance DB in the server dialog.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com