Re: Problems with pgagent Jobs

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

> -----Original Message-----
> From: Selber, Heiko [mailto:heiko(dot)selber(at)siemens(dot)com] 
> Sent: 01 June 2006 16:35
> To: Dave Page; pgadmin-support(at)postgresql(dot)org
> Subject: AW: [pgadmin-support] Problems with pgagent Jobs
> 
> It is a different database on a different host, but the setup 
> should be
> theoretically the same. Only that they were installed by two different
> persons.
> 
> And no, I didn't specify a host agent.

Can you send a pg_dump of the pgagent schema from both machines please?

> It is good news that I don't have to reinstall. But perhaps a service
> restart or reboot would help? There might be stale locks 
> somewhere (I am
> only guessing).

You can try, but I'd be amazed if it helped.

Regards, Dave

PS. I'm on holiday for a week after today so responses to emails might
be delayed!