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
serviceand 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)(byinstalling 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
databaseserver: 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