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@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@491cc8cbb9c2:/# service postgresql start* Starting PostgreSQL 9.4 database server
[ OK ]
root@491cc8cbb9c2:/# su - postgres
postgres@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@491cc8cbb9c2:/usr/share/postgresql/9.4/extension$ ls pgagent*
ls: cannot access pgagent*: No such file or directory
postgres@491cc8cbb9c2:/usr/share/postgresql/9.4/extension$
So where is it?
root@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?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com