Thread: pgagent DEB packages do not support postgres 9.4
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
On Thu, Jul 2, 2015 at 9:38 PM, Josh Berkus <josh@agliodbs.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@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? 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
On 07/03/2015 01:05 AM, Dave Page wrote: >> > ... 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. That's why I cc'd Christoph. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com
Re: Josh Berkus 2015-07-02 <5595A156.2070503@agliodbs.com> > 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: Hi, pgagent had not been rebuilt for quite a while which is why it didn't have 9.4 (and jessie) support yet. Fixed now: old: Package: pgagent Version: 3.4.0-2.pgdg+1 Postgresql-Version: 9.1 9.2 9.3 new: Package: pgagent Version: 3.4.0-3.pgdg+1 Postgresql-Version: 9.1 9.2 9.3 9.4 Our build system isn't very smart yet about nudging us to rebuild everything once a new PG major is released. I hope to fix that once the pgapt django app gets deployed on www.postgresql.org. I need to poke Magnus to really review it soonish... Christoph -- cb@df7cb.de | http://www.df7cb.de/
On 07/05/2015 01:38 PM, Christoph Berg wrote: > pgagent had not been rebuilt for quite a while which is why it didn't > have 9.4 (and jessie) support yet. Fixed now: Thanks! -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com
On 07/05/2015 10:27 PM, Josh Berkus wrote: > On 07/05/2015 01:38 PM, Christoph Berg wrote: >> pgagent had not been rebuilt for quite a while which is why it didn't >> have 9.4 (and jessie) support yet. Fixed now: > > Thanks! Oh, also, tested and verified. New packages work with 9.4. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com
Re: Josh Berkus 2015-07-06 <559AC4FF.1040402@agliodbs.com> > On 07/05/2015 10:27 PM, Josh Berkus wrote: > > On 07/05/2015 01:38 PM, Christoph Berg wrote: > >> pgagent had not been rebuilt for quite a while which is why it didn't > >> have 9.4 (and jessie) support yet. Fixed now: > > > > Thanks! > > Oh, also, tested and verified. New packages work with 9.4. Cool, thanks for the feedback! Christoph -- cb@df7cb.de | http://www.df7cb.de/