Message-ID: <76dfe96c8abe24e76e0c8f27a1537ae9f8c811c2.camel@gunduz.org>
Subject: Re: RPM Morgue
From: Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= <devrim@gunduz.org>
To: Craig Ringer <craig@2ndquadrant.com>, pgsql-pkg-yum
	 <pgsql-pkg-yum@postgresql.org>
Date: Wed, 27 Jun 2018 00:40:54 +0100
In-Reply-To: 
 <CAMsr+YHGvn-7nyFUncdVHR_Q5i2Kc19jy_RAvmt-g9O5iMKUqg@mail.gmail.com>
References: 
	<CAMsr+YHGvn-7nyFUncdVHR_Q5i2Kc19jy_RAvmt-g9O5iMKUqg@mail.gmail.com>
Content-Type: multipart/signed; micalg="pgp-sha256";
	protocol="application/pgp-signature"; boundary="=-5MUxuaGQfIj6skIHS0zD"
Mime-Version: 1.0
Precedence: bulk


--=-5MUxuaGQfIj6skIHS0zD
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable


Hi Craig,

On Mon, 2018-06-25 at 09:42 +0800, Craig Ringer wrote:

> The apt.postgresql.org crew have a package morgue for old versions at
> atalia.postgresql.org/morgue/ . It's not a full repo, but you can fish ou=
t
> needed packages manually and install them. This is a *lifesaver* when
> trying to examine a core file a customer system where debuginfo wasn't
> installed, or trying to reproduce a subtle version-specific issue.
>=20
> Do you have anything like that? If not, do you have any interest in it? I=
'd
> really like to get something like it going, and rather than creating one
> in-house at 2ndQ where nobody else lands up benefiting, it might make sen=
se
> to help out with one for the community.
>=20
> What I'm thinking of is a selective rsync to an archive repo, where
> packages get copied but never get deleted, then createrepo_c runs in
> incremental mode (--update --retain-old-md-by-age=3D5d) to index them.
>=20
> So it doesn't upset https://yum.postgresql.org/, but
> https://yum-archive.postgresql.org/ or whatever can keep a deep history o=
f
> packages.
>=20
> An alternative is to ditch the repo indexing and use an AWS S3 bucket to
> host an unindexed package slush pile, like the apt morgue. createrepo can=
't
> run sensibly on s3-hosted files. But s3 is cheap - 2c/gb/month, or less i=
f
> you go for infrequent access mode.
>=20
> Thoughts?

I'm not against keeping the old package, but there are two things:

* We need to ask sysadmins team, because this means a lot of extra disk spa=
ce.

* Building older packages is not that hard with the RPMs as you know -- jus=
t
change the version number, and run make rpm11 (or whatever). I'm not sure t=
hat
keeping the old packages are worth the hassle.

Again, I'm not against the idea as long as you can convince sysadmin team, =
and
also write scripts to pull the packages :)

Cheers,
--=20
Devrim G=C3=BCnd=C3=BCz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
--=-5MUxuaGQfIj6skIHS0zD
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNATURE-----

iQIzBAABCAAdFiEEH8GKHNUOKtDEiyD22MM9/pLPbrUFAlsyzwYACgkQ2MM9/pLP
brUQZxAAs199jO0mEh+fqSOoDxiYIwKEeu0XvHnO3pgmfbWTfwnZYXV+zBCC8s6z
8f+3xKtAIWVN7553TUKIzYE2SJ9SUDC94t5D3Eqa/KRagdbUHL7vxMeFNK9SxegG
ITkKpY65skDiYwE59zEul6vVgtgYNkw6U8Rhhwq2L5NqK+hpvlTRrEmVL6lfXnzo
6S8c2v57TjnAKFeAY/8L45aU4M/Lkj8aPaKvhZivoiTXzUqOGT7nDPKvUlby7XQ1
ELW8VI+5oUb0Ox97VGFoHO1HgDuSJuMdc/c2O43aZVleANixhj5bfmPdsZmnnSMx
Ux2STiGM1rLSAkxM0Diyz84/sjCri73H8n/FWeKaFiphpmb9jZIkhY/ZbbQff5cA
x3kXbg91PvrVWwW1j/cklYD5YZSaxg6ABBPEvvLYlQFr4eYQLT/pqy0iMBTq+KXK
QskeqiV9r2yDkBNCmc+103RzeroWa41P8x5eg8gqYUDxXbT88B+2L4R2HQmaMC18
/PLQ1tUZpGw+EpC39sdJD9WYZjlgpBi6XMQyNzdFEMD+UrCoDDoW05geJkSg1Kvm
NR+VEYFEDXYhL2kbIvQ/cSyTocxXJAfwzYGiNnmHyvfNQ+L9O+lw6irq36xOJtpC
ccBUNwxoCVTQTWwqK0R5M9kgwdn04RIjnsk+Q5ADO2UehRHU9nw=
=sxqX
-----END PGP SIGNATURE-----

--=-5MUxuaGQfIj6skIHS0zD--