Re: Problems with pgagent Jobs

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: "Selber, Heiko" <heiko(dot)selber(at)siemens(dot)com>
Cc: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Problems with pgagent Jobs
Date: 2006-06-06 21:13:20
Message-ID: 20060606211320.GD45331@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Fri, Jun 02, 2006 at 03:57:21PM +0200, Selber, Heiko wrote:
> 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.

Dumb question: any reason that script doesn't wrap everything into a
transaction?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-06-12 07:12:51 Re: Postgres question
Previous Message Nate.Ingalsbe 2006-06-06 18:58:10 Server Instrumentation for Gentoo Portage Install