Обсуждение: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast, a leader in email security and cyber resilience. Mimecast integrates email defenses with brand protection, security awareness training, web security, compliance and other essential capabilities. Mimecast helps protect large and small organizations from malicious activity, human error and technology failure; and to lead the movement toward building a more resilient world. To find out more, visit our website.

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast, a leader in email security and cyber resilience. Mimecast integrates email defenses with brand protection, security awareness training, web security, compliance and other essential capabilities. Mimecast helps protect large and small organizations from malicious activity, human error and technology failure; and to lead the movement toward building a more resilient world. To find out more, visit our website.

On 15/06/2022 11:58, Ian Dauncey wrote:
> According to the apt list for PostgreSQL there is nothing for the s390 
> system for version 13 and 14.

That is more than likely your answer, so.... I'm not knowledgable on 
these things, but perhaps the packagers will be able to say more. I'd be 
guided by that page in any case.

Ray.

-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie

Ian Dauncey <Ian.Dauncey@bankzero.co.za> writes:
> Currently we are running PostgreSQL 12.2 on Ubuntu 20.04.1 LTS (Kernel: Linux 5.4.0-42-generic - Architecture:
s390x).
> We are looking at upgrading to a later version of PostgreSQL
> My question is :- What is the latest available version of PostgreSQL that will run on the above Architecture.

No support has been dropped at the source level, so any PG version ought
to work there.  But you might have to build it yourself --- which versions
are available in binary form from prebuilt repositories is a very
different question.

I'd try grabbing the SRPM for whichever version you want and seeing
if it doesn't build on your machine.  Building from SRPMs is not hard,
and it's a good skill to acquire if you're using non-mainstream
hardware.

            regards, tom lane

On 6/15/22 03:58, Ian Dauncey wrote:
> According to the apt list for PostgreSQL there is nothing for the s390 
> system for version 13 and 14.
> 

> But for version 12 there is
> 
> # sudo apt list postgresql-12 -a
> 
> Listing... Done
> 
> postgresql-12/focal-updates,focal-security,now 12.11-0ubuntu0.20.04.1 
> s390x [installed]

This is from the Ubuntu repo and Ubuntu pins a Postgres version to each 
Ubuntu version in its repos. That means there will not be newer versions 
available.

The community repo:

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

does not support s390, so that is not a solution.

As Tom Lane said you have the options of building from source or SRPM.

> 
> postgresql-12/focal 12.2-4 s390x
> 
> Regards
> 
> Ian
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com