Re: running jobs on a distant machine

On Tue, Jan 6, 2009 at 9:23 AM, houssem jemel <houssem20(at)yahoo(dot)fr> wrote:
> Hello
>
> I have installed postgresql on a machine (lets call it A), in order to run jobs
> In that machine all is right, i lunch pgadmin, install the service, and i could run the jobs
> My problem is when i wanted to execute jobs in a distant machine, lets call it B
> So I have installed pgadmin, install the service as : "c:/program files/pgadmin III/1.8/ pgAgent INSTALL pgAgent -u user -p password hostaddr=127.0.0.1 dbname=postgres user=postgres"
> In the machine A which contains the base i created a job. This job is supposed to execute a script in the machine B.
> So i put the path of this script in Defenition ("C:\test.bat"), and i Put the IP of the machine B in the field Host Agent
> But That did not work.

The Host Agent field needs a hostname, not an IP address. With pgAgent
running on machine B, run the following query on machine A in the
database containing the pgAgent schema:

select jagstation from pgagent.pga_jobagent;

That will show you the hostnames of each agent as pgAgent sees them.
Use the appropriate one in the host agent field.

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com