| From: | houssem jemel <houssem20(at)yahoo(dot)fr> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re : Re : Problem in connecting pgagent service to the database server |
| Date: | 2008-12-04 15:17:22 |
| Message-ID: | 480140.47501.qm@web25214.mail.ukl.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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 <houssem20(at)yahoo(dot)fr>
À : pgadmin-support(at)postgresql(dot)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 <houssem20(at)yahoo(dot)fr>
À : pgadmin-support(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 田中 太郎 | 2008-12-18 03:31:57 | edb-debugger- help |
| Previous Message | houssem jemel | 2008-12-04 15:12:45 | Re : Problem in connecting pgagent service to the database server |