Re: Packaging automation, testing and work-reduction

On 08/20/2014 02:01 AM, Jeff Frost wrote:
> This all sounds exciting, but since Devrim is out, let's table the discussion till he gets back (or at least gets
neara keyboard). 

Sensible.

BTW, I've been doing some verification of the PGDG repos with repocirc
after having a series of problems getting things to install.

It's spotting a fair few new issues, as well as those I've already
raised in
http://www.postgresql.org/message-id/53EC38F5.9080500@2ndquadrant.com
and http://www.postgresql.org/message-id/53F37253.4000706@2ndquadrant.com .

For example, 9.3 on RHEL5:

sudo repoclosure  -n -c /tmp/yum.conf -r pgdg93 -l core -l update -l extras

with the attached yum.conf, where it's checking pgdg93 against RHEL core
and updates plus EPEL, reports quite a bit of breakage (my comments inline):


package: ora2pg-12.0-1.rhel5.noarch from pgdg93
  unresolved deps:
     perl(DBD::Oracle)
package: pg_activity-0.2.0-1.rhel5.noarch from pgdg93
  unresolved deps:
     python > 0:2.6
     python-psycopg2 > 0:2.2.1
     python-psutil > 0:0.5.1
package: pg_comparator93-2.2.2-1.rhel5.x86_64 from pgdg93
  unresolved deps:
     perl-Pod-Usage
package: pgdg-sl93-9.3-1.noarch from pgdg93
  unresolved deps:
     sl-release
package: pgtap93-0.94.0-1.rhel5.noarch from pgdg93
  unresolved deps:
     perl-Test-Harness >= 0:3.0
package: usda-r18-1.0-2.rhel5.noarch from pgdg93
  unresolved deps:
     postgresql91


There's a packaging bug in usda, pg_activity depends on Python > 2.6 (on
RHEL5?!?) and there are a bunch of unsatisfied module dependencies that
need fixing, or documenting to explain where to get them from.

Now if I remove EPEL (which PGDG doesn't officially depend on), I get a
*lot* more issues. (I've removed entries already fully covered above,
these are just the new EPEL dependencies):



package: ora2pg-12.0-1.rhel5.noarch from pgdg93
  unresolved deps:
     perl(DBD::Oracle)  # covered above
     perl(IO::Compress::Base)
     perl(String::Random)
package: pg_partman93-1.7.0-1.rhel5.x86_64 from pgdg93
  unresolved deps:
     python-psycopg2
package: pgadmin3_93-1.18.0-1.rhel5.i386 from pgdg93
  unresolved deps:
     libwx_gtk2u_xrc-2.8.so.0(WXU_2.8)
     libwx_gtk2u_core-2.8.so.0(WXU_2.8)
     libwx_baseu-2.8.so.0(WXU_2.8.5)
     libwx_gtk2u_aui-2.8.so.0(WXU_2.8)
     libwx_gtk2u_adv-2.8.so.0(WXU_2.8)
     libwx_gtk2u_stc-2.8.so.0
     libwx_gtk2u_xrc-2.8.so.0
     libwx_gtk2u_adv-2.8.so.0
     libwx_gtk2u_core-2.8.so.0
     libwx_gtk2u_aui-2.8.so.0
     libwx_baseu_net-2.8.so.0(WXU_2.8)
     libwx_gtk2u_html-2.8.so.0(WXU_2.8)
     wxGTK
     libwx_baseu-2.8.so.0
     libwx_baseu_xml-2.8.so.0
     libwx_baseu_xml-2.8.so.0(WXU_2.8)
     libwx_gtk2u_stc-2.8.so.0(WXU_2.8)
     libwx_gtk2u_html-2.8.so.0
     libwx_gtk2u_aui-2.8.so.0(WXU_2.8.5)
     libwx_baseu_net-2.8.so.0
     libwx_baseu-2.8.so.0(WXU_2.8)
package: pgloader-2.3.2-1.rhel5.x86_64 from pgdg93
  unresolved deps:
     python-psycopg2
package: pgpool-II-93-3.3.2-1.rhel5.x86_64 from pgdg93
  unresolved deps:
     libmemcached.so.2()(64bit)
     libmemcached.so.2(libmemcached_2)(64bit)
package: plr93-8.3.0.15-1.rhel5.x86_64 from pgdg93
  unresolved deps:
     libR.so()(64bit)
package: postgis2_93-2.1.3-1.rhel5.x86_64 from pgdg93
  unresolved deps:
     json-c
     hdf5
     libjson.so.0()(64bit)
package: postgresql93-contrib-9.3.5-1PGDG.rhel5.x86_64 from pgdg93
  unresolved deps:
     libossp-uuid.so.15()(64bit)
package: postgresql_autodoc-1.41-1.rhel5.noarch from pgdg93
  unresolved deps:
     perl(HTML::Template)
     perl-TermReadKey
     perl(Term::ReadKey)
package: skytools-93-3.1.5-1.rhel5.x86_64 from pgdg93
  unresolved deps:
     python-psycopg2


so I think PGDG already depends on EPEL. It just doesn't declare it, do
so systematically, or manage those dependencies.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services