Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group