I found the mistake i put host all all 0.0.0.1/0 trust That would accept any connection
----- Message d'origine ---- De : houssem jemel <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Jeudi, 4 Décembre 2008, 16h12mn 45s Objet : Re : Problem in connecting pgagent service to the database server That may help you to diagnostic the problem: I open the pgadmin in the distant machine 192.168.1.2, and tried to connect to the database server I got this error : Error connecting to the server: FATAL , no entry in pg_hba.conf for host 192.168.1.2 Althoug i put in the pg_hba.conf host all all 127.0.0.1/32 trust that normally accept any connection ----- Message d'origine ---- De : houssem jemel <[EMAIL PROTECTED]> À : pgadmin-support@postgresql.org Envoyé le : Jeudi, 4 Décembre 2008, 16h03mn 05s Objet : Problem in connecting pgagent service to the database server Hello, I have installed PotgreSQL in a machine that is turning in win 2003 (lets say IP 192.168.1.1) , i have installed thes service and all is turning good (jobs are running) Then i wanted to target a distant machine. I have installed the service in that distant machine (lets say IP 192.168.1.2)(by installing pgadmin III) I launch the service by the command C:\Program Files\pgAdmin III\pgAgent INSTALL pgAgent -u postgres -p secret hostaddr=[IP of the machine turning the database server: 192.168.1.1] dbname=postgres user=postgres and then started the service : Net start pgAgent In Pgadmin Job i put in host agent IP where the service is turning : 192.168.1.2 then i changed the pg_hba.conf in the server and put host all all 127.0.0.1/32 trust in the definition of job i put the local path to the script (althoug it is in the distant machine 192.168.1.2) ex: C:\temp\test.bat Is what i did correct ? Why could i not run the batch in the distant machine ? Thank you for your help -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
