From: | "Marie-Claude QUIDOZ" <Marie-Claude(dot)QUIDOZ(at)cefe(dot)cnrs(dot)fr> |
---|---|
To: | "Guillaume Lelarge" <guillaume(at)lelarge(dot)info> |
Cc: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: problem with access database |
Date: | 2010-10-04 16:36:02 |
Message-ID: | AE1706B5C143C44589513A92F5945DB7673718@ZZML.newcefe.newage.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello
> 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.
Yes I haven't change because I don't know what to put. I have the choice between postgres, edb or template1 and I don't find any documentation to help me to understand. I don't understand what is "maintenance DB"
Bye
MCQ
-----Message d'origine-----
De : Guillaume Lelarge [mailto:guillaume(at)lelarge(dot)info]
Envoyé : vendredi 1 octobre 2010 23:20
À : Marie-Claude QUIDOZ
Cc : pgadmin-support(at)postgresql(dot)org
Objet : Re: [pgadmin-support] 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.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-10-04 16:41:27 | Re: problem with access database |
Previous Message | Guillaume Lelarge | 2010-10-03 22:53:54 | Re: pgadmin III 1.12 |