Обсуждение: running jobs on a distant machine
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. I am using 2 windows, No pb of connection since i can see and open the jobs database from the pgadmin of the machine B I am using Pgadmin 1.8.4 In Machine A and 1.8.3 in B Thank you for help
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
Yes i changed the hostaddr to thi IP of B, i got then the entrie of B The job on B is now runninig Thank you for Help ----- Message d'origine ---- De : Dave Page <dpage@pgadmin.org> À : houssem jemel <houssem20@yahoo.fr> Envoyé le : Mardi, 6 Janvier 2009, 12h16mn 01s Objet : Re: Re : [pgadmin-support] running jobs on a distant machine [Please keep replies on-list] On Tue, Jan 6, 2009 at 11:07 AM, houssem jemel <houssem20@yahoo.fr> wrote: > the command show only one entrie wihch is of the machine A > Also i tried to do a telnet on 5432 from A to B but failed, is it normal > can you also verify the command i put in B > c:/program files/pgadmin III/1.8/ pgAgent INSTALL pgAgent -u user -p password hostaddr=127.0.0.1 dbname=postgres user=postgres > in service pgAgent is marked started Shouldn't hostaddr= have the address of machine A, and not the loopback address? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
sorry i wanted to say: i changed the hostaddr to thi IP of A not B ----- Message d'origine ---- De : houssem jemel <houssem20@yahoo.fr> À : Dave Page <dpage@pgadmin.org> Cc : pgadmin-support@postgresql.org Envoyé le : Mardi, 6 Janvier 2009, 15h02mn 02s Objet : Re : Re : [pgadmin-support] running jobs on a distant machine Yes i changed the hostaddr to thi IP of B, i got then the entrie of B The job on B is now runninig Thank you for Help ----- Message d'origine ---- De : Dave Page <dpage@pgadmin.org> À : houssem jemel <houssem20@yahoo.fr> Envoyé le : Mardi, 6 Janvier 2009, 12h16mn 01s Objet : Re: Re : [pgadmin-support] running jobs on a distant machine [Please keep replies on-list] On Tue, Jan 6, 2009 at 11:07 AM, houssem jemel <houssem20@yahoo.fr> wrote: > the command show only one entrie wihch is of the machine A > Also i tried to do a telnet on 5432 from A to B but failed, is it normal > can you also verify the command i put in B > c:/program files/pgadmin III/1.8/ pgAgent INSTALL pgAgent -u user -p password hostaddr=127.0.0.1 dbname=postgres user=postgres > in service pgAgent is marked started Shouldn't hostaddr= have the address of machine A, and not the loopback address? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support