Обсуждение: pgAgent setup
Hi,
I've installed the latest PostgreSQL release, 8.1-beta4 with default settings.
I installed the 'pgagent.sql' script and the service with the following command :
pgAgent INSTALL pgAgent -u postgres -p postmaster hostaddr=127.0.0.1 dbname=postgres user=postgres
I've installed the latest PostgreSQL release, 8.1-beta4 with default settings.
I installed the 'pgagent.sql' script and the service with the following command :
pgAgent INSTALL pgAgent -u postgres -p postmaster hostaddr=127.0.0.1 dbname=postgres user=postgres
windows user (created during the installation process)
user= postgres
password = postmaster
user= postgres
password = postmaster
postgresql user
user=postgres
password=postgres
user=postgres
password=postgres
I run the service with no errors.
I then created a job to fill a table with the current date and time as follow but it never run and the statistics are empty.
When refreshing, the Next run field does not change
job1
Name job1
Enabled Yes
Host agent localhost
Job class Routine maintenance
Created 24/10/2005 18.44.49
Changed 24/10/2005 18.44.49
Next run 24/10/2005 19.19.00
Last run
Last result Unknown
Running at Not currently running
Name job1
Enabled Yes
Host agent localhost
Job class Routine maintenance
Created 24/10/2005 18.44.49
Changed 24/10/2005 18.44.49
Next run 24/10/2005 19.19.00
Last run
Last result Unknown
Running at Not currently running
schedule1
Name schedule1
ID 1
Enabled Yes
Start date 24/10/2005 19.17.00
End date 29/10/2005 0.00.00
Minutes Every minute
Hours Every hour
Weekdays Any day of the week
Monthdays Every day
Months Every months
step1
Name step1
ID 1
Enabled Yes
Kind SQL
Database testdb
Code insert into test values(now());
On error fail
Name step1
ID 1
Enabled Yes
Kind SQL
Database testdb
Code insert into test values(now());
On error fail
Any idea on what am I doing wrong?
Thanks,
Paolo
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Paolo Saudin
Sent: 24 October 2005 19:02
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] pgAgent setupHi,
I've installed the latest PostgreSQL release, 8.1-beta4 with default settings.
I installed the 'pgagent.sql' script and the service with the following command :
pgAgent INSTALL pgAgent -u postgres -p postmaster hostaddr=127.0.0.1 dbname=postgres user=postgreswindows user (created during the installation process)
user= postgres
password = postmasterpostgresql user
user=postgres
password=postgresI run the service with no errors.I then created a job to fill a table with the current date and time as follow but it never run and the statistics are empty.When refreshing, the Next run field does not changejob1
Name job1
Enabled Yes
Host agent localhost
Job class Routine maintenance
Created 24/10/2005 18.44.49
Changed 24/10/2005 18.44.49
Next run 24/10/2005 19.19.00
Last run
Last result Unknown
Running at Not currently running
I suspect the problem is that your host agent is not actually localhost - pgAgent uses the wxGetFullHostName (http://wxwidgets.org/manuals/2.6.2/wx_networkfunctions.html#wxgetfullhostname) function which returns the fully qualified domain host name of the machine it's running on. In my case that might be pc30.vale-housing.co.uk for example.
Unless you are running multiple agents and need to target jobs at specific ones, it's normally safe to leave this field blank which means that any agent can run the job.
Regards, Dave