Skip site navigation (1) Skip section navigation (2)

Problem in connecting pgagent service to the database server

From: houssem jemel <houssem20(at)yahoo(dot)fr>
To: pgadmin-support(at)postgresql(dot)org
Subject: Problem in connecting pgagent service to the database server
Date: 2008-12-04 15:03:05
Message-ID: 373938.39079.qm@web25214.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgadmin-support
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


      

pgadmin-support by date

Next:From: houssem jemelDate: 2008-12-04 15:12:45
Subject: Re : Problem in connecting pgagent service to the database server
Previous:From: Ashesh VashiDate: 2008-12-04 12:37:40
Subject: Re: Not able to type in fields 1.8.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group