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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
