Thread: Who and How is responsible for released installations packages and3rd party packs? (e.g. on https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/)

Hi PG Community,

In my company I found that PG Installation on deployed OS Images are takne from here: https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/

We are using PG 9.6.5 or 9.6.7 + pgpool + plv8 + others

Some or RPMs for CentOS are taken from that URL (PG Installation, plv8).

My question is:
Who is building RPMs and uploading to that URL? What are the criteria to build one RPM or other and their versions?
Why I am asking:
I saw on URL there are PG 9.6.8 and 9.6.9 - Are there maintained only latest 2 build releases?

plv8 - there are versions 2.0.0-1 and 2.1.0, since latest plv8 are already 2.3.7 and latest for 2.1.X is 2.1.3 contating major fixes


Thanks,
AlexL
On 08/01/2018 10:53 PM, Alexandru Lazarev wrote:
> Hi PG Community,
> 
> In my company I found that PG Installation on deployed OS Images are 
> takne from here: https://yum.postgresql.org/9.6/redhat/rhel-7.3-x86_64/
> 
> We are using PG 9.6.5 or 9.6.7 + pgpool + plv8 + others
> 
> Some or RPMs for CentOS are taken from that URL (PG Installation, plv8).
> 
> My question is:
> Who is building RPMs and uploading to that URL? What are the criteria to 
> build one RPM or other and their versions?

https://www.postgresql.org/download/linux/redhat/

https://yum.postgresql.org/

> Why I am asking:
> I saw on URL there are PG 9.6.8 and 9.6.9 - Are there maintained only 
> latest 2 build releases?
> 
> plv8 - there are versions 2.0.0-1 and 2.1.0, since latest plv8 are 
> already 2.3.7 and latest for 2.1.X is 2.1.3 contating major fixes
> 
> 
> Thanks,
> AlexL


-- 
Adrian Klaver
adrian.klaver@aklaver.com


Hi,

On Thu, 2018-08-02 at 08:53 +0300, Alexandru Lazarev wrote:
> I saw on URL there are PG 9.6.8 and 9.6.9 - Are there maintained only
> latest 2 build releases?

Yes, older releases are deleted automagically.

Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Attachment
Thanks all for responses.

Let me ask other dummy question:
plv8 RPMs were built by PostgreSQL Community for different OSes, or by those OSes vendors/community (e.f. RedHat/Debian, etc)?
And the same question about postgresql-server install packages themselves (RPMs, debs, etc)

Thanks in advance

On Mon, Aug 6, 2018 at 12:02 AM, Devrim Gündüz <devrim@gunduz.org> wrote:

Hi,

On Thu, 2018-08-02 at 08:53 +0300, Alexandru Lazarev wrote:
> I saw on URL there are PG 9.6.8 and 9.6.9 - Are there maintained only
> latest 2 build releases?

Yes, older releases are deleted automagically.

Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

On 08/06/2018 03:49 PM, Alexandru Lazarev wrote:

> And the same question about postgresql-server install packages themselves
> (RPMs, debs, etc)

For this one, packages you get from "PGDG"@
https://www.postgresql.org/download/ are built by postgres. RedHat, for
example, also has postgres built by them and included in the
distribution -- in RHEL7 it's v.9.2 but RedHat is known to patch code
without changing version numbers.

--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu


Attachment
Hi,

On Mon, 2018-08-06 at 23:49 +0300, Alexandru Lazarev wrote:

> Let me ask other dummy question:
> plv8 RPMs were built by PostgreSQL Community for different OSes, or by
> those OSes vendors/community (e.f. RedHat/Debian, etc)?
> And the same question about postgresql-server install packages themselves
> (RPMs, debs, etc)

There are community RPMs, and then the RPMs supplied by Red Hat / CentOS  via OS or SCL.

Community packages has wider range of supported PostgreSQL versions, and wider range of packages.

Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Attachment
On 08/10/2018 02:49 PM, Christoph Berg wrote:

> plv8 will work for anyone willing to go through that. It's just not
> feasible to support it from a packager perspective.

Hm. Gotta wonder if running this:
https://github.com/clkao/docker-postgres-plv8/blob/master/10-2/Dockerfile
and copying plv8.so out of the resulting image is the easy way out.

--
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu


Attachment