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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] > so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
