Re: PostgreSQL Minor Release Retention Policy - Mailing list pgsql-pkg-yum

From Devrim Gündüz
Subject Re: PostgreSQL Minor Release Retention Policy
Date
Msg-id 1475789484.3515.54.camel@gunduz.org
Whole thread Raw
In response to PostgreSQL Minor Release Retention Policy  (Jason Petersen <jason@citusdata.com>)
List pgsql-pkg-yum
Hi Jason,

On Thu, 2016-10-06 at 14:04 -0600, Jason Petersen wrote:
> In a blog post, Devrim wrote: "This means, when there is new release
> available, we will delete n-3th one. This is a policy to keep the repo clean.
> This does not apply for PostgreSQL major releases”
>
> I take it this actually means release and not version, right? For instance,
> last I checked we had 9.5.3-2, 9.5.4-1, and 9.5.4-2 in there. So if I know
> I’m on 9.5.4, I’m not automatically safe until 9.5.7… my package may
> disappear as soon as 9.5.5 if there is enough RPM release churn?

repomanage script, ( part of yum-utils and dnf) that we use for cleaning up old
packages, has this option:

  -k KEEP, --keep=KEEP  newest N packages to keep - defaults to 1

So, I set -k 3 in our sync scripts.

What does it mean? Under normal circumstances, if we don't make any packaging
mistakes, when we release 9.5.5, then 9.5.2 will be removed, so we'll keep the
latest 3 versions.

However, there is a minor potential problem in here: If we release 9.5.5-2,
then 9.5.3 will be removed, so practically we'll have only 2 versions (?).

> This makes it pretty unsafe to hardcode a full version specifier in e.g. a
> Dockerfile or other system meant to produce repeatable results, but I suppose
> people can just run their own package mirrors if they desire a different
> retention policy.

Right. 

Why do you hardcode postgresql RPMs in Dockerfile, btw? 

Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Attachment

pgsql-pkg-yum by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: Amazon Linux RPM Changes
Next
From: Devrim Gündüz
Date:
Subject: Re: Broken python3-psycopg2 for F24 / PG 9.6