Re: pgagent jobs never start

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: Hogan, James F. Jr. [mailto:JHogan(at)seton(dot)org] 
> Sent: 16 January 2006 17:41
> To: Dave Page
> Subject: RE: [pgadmin-support] pgagent jobs never start
> 
> I did in fact have two separate databases one named 
> "postgres" the other
> named "hogan"
> 
> I was hopeful that you were on to my trouble...However....
> 
> I have deleted the "hogan" database and created a schema 
> "hogan" within
> the database "posgtres"
> 
> Created a new table within the "hogan" schema
> 
> "hogan".testagent
> 
> Validated that account 'svc_pgsql' has sufficient rights.
> 
> Both server and agent services run under 'svc_pgsql'
> 
> Deleted old job and created new to run every minute
> 
> Insert into "hogan".testagent Values (default, 'hogan')
> 
> Restarted both Windows Services...first the Posgtres Service then the
> PGAgent Service
> 
> The New Job still fails to start...
> 
> 
> 
>  Attached result of 
> 
> Pg_dump -f c:\pgagent2.sql -U svc_pgsql postgres
> 
> After changes noted above.

OK, loaded that into my master connection DB, installed pgAgent, started
it up and away it went inserting rows into the test table. So, I suspect
the agent service is failing to connect to your database for some
reason. 

Is there anything obvious in the event log? If not can you remove and
add the service again with the -l 2 option please? That will cause a
bunch of debug output to be logged to the Application event log, and
should include some hints as to what's going on.

Regards, Dave.