pgAgent problem - always runs jobs at every poll

Hi there,

I'm having an issue with pgAgent which I'm sure is related to this bug:

http://archives.postgresql.org/pgadmin-support/2007-11/msg00098.php

I'm on Solaris x86, using pgAdmin 1.8.0 (the latest available build for this
OS)

When I start pgagent, I get this error though:

DEBUG: Database sanity check

DEBUG: Clearing zombies

18:56:08: Error: Cannot get the hostname (error 0: Error 0)

DEBUG: Checking for jobs to run

I've looked through the source, and it's probably here that it's failing.

int MainRestartLoop(DBconn *serviceConn)

.

wxString hostname = wxGetFullHostName();

.

Any idea as to why the hostname is not being returned? This is the cause of
the problem, I think.

Essentially, the SQL being issued is this:

SELECT J.jobid

FROM pgagent.pga_job J

WHERE jobenabled

AND jobagentid IS NULL

AND jobnextrun <= now()

AND jobhostagent = '' OR jobhostagent = ''

ORDER BY jobnextrun

So it ALWAYS returns the jobs, regardless of whether they're enabled or not.
Hence, they run at every single poll!

Many thanks

Andy Tilley