On Tue, Jan 6, 2009 at 9:23 AM, houssem jemel <housse...@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
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
