Re: pgagent DEB packages do not support postgres 9.4

On Thu, Jul 2, 2015 at 9:38 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> Folks:
>
> On Ubuntu 14.04, for the database server, there is a single pgagent
> meta-package which is supposed ot cover all versions of Postgres. But
> it fails:
>
> root(at)491cc8cbb9c2:/# apt-get install pgagent
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> The following extra packages will be installed:
> libwxbase3.0-0
> Suggested packages:
> pgadmin3
> The following NEW packages will be installed:
> libwxbase3.0-0 pgagent
> 0 upgraded, 2 newly installed, 0 to remove and 21 not upgraded.
> Need to get 1012 kB of archives.
> After this operation, 3444 kB of additional disk space will be used.
> Do you want to continue? [Y/n] Y
> Get:1 http://archive.ubuntu.com/ubuntu/ trusty/universe libwxbase3.0-0
> amd64 3.0.0-2 [946 kB]
> Get:2 http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg/main pgagent
> amd64 3.4.0-2.pgdg14.04+1 [65.5 kB]
> Fetched 1012 kB in 1s (813 kB/s)
> Selecting previously unselected package libwxbase3.0-0:amd64.
> (Reading database ... 13052 files and directories currently installed.)
> Preparing to unpack .../libwxbase3.0-0_3.0.0-2_amd64.deb ...
> Unpacking libwxbase3.0-0:amd64 (3.0.0-2) ...
> Selecting previously unselected package pgagent.
> Preparing to unpack .../pgagent_3.4.0-2.pgdg14.04+1_amd64.deb ...
> Unpacking pgagent (3.4.0-2.pgdg14.04+1) ...
> Processing triggers for postgresql-common (169.pgdg14.04+1) ...
> Building PostgreSQL dictionaries from installed myspell/hunspell packages...
> Removing obsolete dictionary files:
> Setting up libwxbase3.0-0:amd64 (3.0.0-2) ...
> Setting up pgagent (3.4.0-2.pgdg14.04+1) ...
> Processing triggers for libc-bin (2.19-0ubuntu6.6) ...
> root(at)491cc8cbb9c2:/# service postgresql start
> * Starting PostgreSQL 9.4 database server
>
> [ OK ]
> root(at)491cc8cbb9c2:/# su - postgres
> postgres(at)491cc8cbb9c2:~$ psql
> psql (9.4.4)
> Type "help" for help.
>
> postgres=# create extension pgagent;
> ERROR: could not open extension control file
> "/usr/share/postgresql/9.4/extension/pgagent.control": No such file or
> directory
> postgres=#
>
> postgres(at)491cc8cbb9c2:/usr/share/postgresql/9.4/extension$ ls pgagent*
> ls: cannot access pgagent*: No such file or directory
> postgres(at)491cc8cbb9c2:/usr/share/postgresql/9.4/extension$
>
> So where is it?
>
> root(at)491cc8cbb9c2:/# find . -name pgagent.control
> ./usr/share/postgresql/9.1/extension/pgagent.control
> ./usr/share/postgresql/9.3/extension/pgagent.control
> ./usr/share/postgresql/9.2/extension/pgagent.control
>
> ... maybe it's time we had pgagent-#.# packages instead?

I don't know who maintains these packages. It's certainly not the
pgAdmin/pgAgent team.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company