MIME-Version: 1.0
From: Craig Ringer <craig@2ndquadrant.com>
Date: Mon, 25 Jun 2018 09:42:28 +0800
Message-ID: 
 <CAMsr+YHGvn-7nyFUncdVHR_Q5i2Kc19jy_RAvmt-g9O5iMKUqg@mail.gmail.com>
Subject: RPM Morgue
To: =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= <devrim@gunduz.org>,
	pgsql-pkg-yum <pgsql-pkg-yum@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009434bc056f6d7ecf"
Precedence: bulk

--0000000000009434bc056f6d7ecf
Content-Type: text/plain; charset="UTF-8"

Devrim, team:

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 out
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.

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 sense
to help out with one for the community.

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=5d) to index them.

So it doesn't upset https://yum.postgresql.org/, but
https://yum-archive.postgresql.org/ or whatever can keep a deep history of
packages.

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 if
you go for infrequent access mode.

Thoughts?

I can always set up my own mirror inhouse for 2ndQ, but I'd rather work
with you.

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

--0000000000009434bc056f6d7ecf
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Devrim, team:</div><div><br></div><div>The <a href=3D=
"http://apt.postgresql.org">apt.postgresql.org</a> crew have a package morg=
ue for old versions at=C2=A0<a href=3D"http://atalia.postgresql.org/morgue/=
">atalia.postgresql.org/morgue/</a> . It&#39;s not a full repo, but you can=
 fish out needed packages manually and install them. This is a *lifesaver* =
when trying to examine a core file a customer system where debuginfo wasn&#=
39;t installed, or trying to reproduce a subtle version-specific issue.</di=
v><div><br></div><div>Do you have anything like that? If not, do you have a=
ny interest in it? I&#39;d really like to get something like it going, and =
rather than creating one in-house at 2ndQ where nobody else lands up benefi=
ting, it might make sense to help out with one for the community.</div><div=
><div><br></div><div>What I&#39;m thinking of is a selective rsync to an ar=
chive repo, where packages get copied but never get deleted, then createrep=
o_c runs in incremental mode (--update --retain-old-md-by-age=3D5d) to inde=
x them.</div><div><br></div><div>So it doesn&#39;t upset=C2=A0<a href=3D"ht=
tps://yum.postgresql.org/">https://yum.postgresql.org/</a>, but <a href=3D"=
https://yum-archive.postgresql.org/">https://yum-archive.postgresql.org/</a=
> or whatever can keep a deep history of packages.</div><div><br></div><div=
>An alternative is to ditch the repo indexing and use an AWS S3 bucket to h=
ost an unindexed package slush pile, like the apt morgue. createrepo can=
9;t run sensibly on s3-hosted files. But s3 is cheap - 2c/gb/month, or less=
 if you go for infrequent access mode.</div><div><br></div><div>Thoughts?</=
div><div><br></div><div>I can always set up my own mirror inhouse for 2ndQ,=
 but I&#39;d rather work with you.</div><div><br></div>-- <br><div class=3D=
"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr">=C2=A0Craig Ringer=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <a href=3D"http://www.2ndQuadrant.com/" t=
arget=3D"_blank">http://www.2ndQuadrant.com/</a><br>=C2=A0PostgreSQL Develo=
pment, 24x7 Support, Training &amp; Services<br></div></div></div></div>
</div></div>

--0000000000009434bc056f6d7ecf--