Re: Problems with pgagent Jobs

["Selber, Heiko" <heiko(dot)selber(at)siemens(dot)com>]

Hi Dave,

no need to send you the dumps; I compared them and saw what was wrong: Some of the functions of pgagent were missing.

Apparently, pgagent.sql had gone only halfway through when it was installed.

I executed the remaining part of pgagent.sql, restarted postgres, and violà it works.

Thank you for your help,

Heiko

> -----Ursprüngliche Nachricht-----
> Von: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] Im Auftrag von Dave Page
> Gesendet: Freitag, 2. Juni 2006 11:57
> An: Selber, Heiko; pgadmin-support(at)postgresql(dot)org
> Betreff: Re: [pgadmin-support] Problems with pgagent Jobs
> 
>  
> 
> > -----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!
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org 
> so that your
>        message can get through to the mailing list cleanly
>