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:guilla...@lelarge.info] Envoyé : vendredi 1 octobre 2010 23:20 À : Marie-Claude QUIDOZ Cc : pgadmin-support@postgresql.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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
