Thread: adminpacks / pgagent / specific version of pg?

adminpacks / pgagent / specific version of pg?

From
Raphaël Enrici
Date:
Dave,

I've read that you are trying to make so that admin-packs will be
directly distributed with PostgreSQL(?). Someone asked at d.o [1] for a
separate packaging of adminpacks. Do you have any idea of the time it
can take to get the files included in PostgreSQL contrib? I'm asking
about that because I'm not sure it's worth doing the effort of a
separate packaging if it get included directly in PostgreSQL rapidly.

Something else, it was also suggested that pgagent get included in the
adminpacks packages. I was persuaded that pgagent was not related to the
version of PostgreSQL used but to the pgAdmin's one. Can you teach me
please?

Regards,
Raph
[1] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=354731

Re: adminpacks / pgagent / specific version of pg?

From
"Dave Page"
Date:

> -----Original Message-----
> From: Raphaël Enrici [mailto:blacknoz@club-internet.fr]
> Sent: 08 May 2006 20:59
> To: Dave Page
> Cc: PgAdmin Hackers
> Subject: adminpacks / pgagent / specific version of pg?
>
> Dave,
>
> I've read that you are trying to make so that admin-packs
> will be directly distributed with PostgreSQL(?).

Yes, it's in the patch queue for 8.2, and so far no-one has objected.

> Someone
> asked at d.o [1] for a separate packaging of adminpacks. Do
> you have any idea of the time it can take to get the files
> included in PostgreSQL contrib? I'm asking about that because
> I'm not sure it's worth doing the effort of a separate
> packaging if it get included directly in PostgreSQL rapidly.

It will be for 8.2.

> Something else, it was also suggested that pgagent get
> included in the adminpacks packages. I was persuaded that
> pgagent was not related to the version of PostgreSQL used but
> to the pgAdmin's one. Can you teach me please?
>
> Regards,
> Raph
> [1] http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=354731

Yes, pgAgent is technically linked to pgAdmin's version, but I hope not to have to make any incompatible changes to the
dataformat so version mixing shouldn't be a problem. There are no known bugs in pgAgent, and no changes planned for
1.6,so that should certainly be the case for the next release at least. 

As for the packaging, normally we ship pgAgent with pgAdmin. There's a couple of vague reasons for that - partly that
it'sthe easiest route, and partly that pgAgent is designed to run on multiple nodes if required so that you can
schedulebatch jobs on any of them, or distribute compute intensive stuff. That said, most people would probably run it
ontheir server anyway for more simple stuff like data summarisation tasks or backups. It's really up to you how you
shipit I guess. 

Regards, Dave.