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@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] Im Auftrag von Dave Page
> Gesendet: Freitag, 2. Juni 2006 11:57
> An: Selber, Heiko; pgadmin-support@postgresql.org
> Betreff: Re: [pgadmin-support] Problems with pgagent Jobs
>
>
>
> > -----Original Message-----
> > From: Selber, Heiko [mailto:heiko.selber@siemens.com]
> > Sent: 01 June 2006 16:35
> > To: Dave Page; pgadmin-support@postgresql.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@postgresql.org
> so that your
> message can get through to the mailing list cleanly
>