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 near a 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