On Tue, Jan 6, 2009 at 9:23 AM, houssem jemel <houssem20@yahoo.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