PostgreSQL on S390x

#1

Post by sbuttgereit » Thu, Nov 23, 2023, 10:23 PM UTC

PostgreSQL on S390x
cybertec-postgresql.com

Re: PostgreSQL on S390x

#2

Post by maximilianburke » Thu, Nov 23, 2023, 11:42 PM UTC

I'm curious who would use Postgres on S390x, and, I guess, who uses Linux on S390x in general?

Re: PostgreSQL on S390x

#3

Post by chasil » Thu, Nov 23, 2023, 11:45 PM UTC

Why not just run it on the Hercules emulator?

https://sdl-hercules-390.github.io/html/

Re: PostgreSQL on S390x

#4

Post by heelix » Fri, Nov 24, 2023, 12:03 AM UTC

maximilianburke wrote: post #2

I'm curious who would use Postgres on S390x, and, I guess, who uses Linux on S390x in general?

Honestly, it just works. I can do a docker image that runs on aarch64, amd64, and s390x. For the SpringBoot apps - the hardware is rock solid and far more important, cheaper and under provisioned than the other 'standard' compute for those who have piles of legacy systems. OpenShift on zSeries is not a lot different than Intel based boxes.

Re: PostgreSQL on S390x

#5

Post by maximilianburke » Fri, Nov 24, 2023, 12:23 AM UTC

heelix wrote: post #4

maximilianburke wrote: post #2

I'm curious who would use Postgres on S390x, and, I guess, who uses Linux on S390x in general?

Honestly, it just works. I can do a docker image that runs on aarch64, amd64, and s390x. For the SpringBoot apps - the hardware is rock solid and far more important, cheaper and under provisioned than the other 'standard' compute for those who have piles of legacy systems. OpenShift on zSeries is not a lot different than Intel based boxes.

Yeah, that all makes sense. Is it just big financial instututions that doing this? I can't go to IBM Cloud and kick off some S390x VMs, can I?

Re: PostgreSQL on S390x

#6

Post by mnd999 » Fri, Nov 24, 2023, 12:45 AM UTC

maximilianburke wrote: post #5

heelix wrote: post #4

Earlier quoted context omitted.

Honestly, it just works. I can do a docker image that runs on aarch64, amd64, and s390x. For the SpringBoot apps - the hardware is rock solid and far more important, cheaper and under provisioned than the other 'standard' compute for those who have piles of legacy systems. OpenShift on zSeries is not a lot different than Intel based boxes.

Yeah, that all makes sense. Is it just big financial instututions that doing this? I can't go to IBM Cloud and kick off some S390x VMs, can I?

If you have an enterprise deal I think you can.

Re: PostgreSQL on S390x

#7

Post by xet7 » Fri, Nov 24, 2023, 12:45 AM UTC

Where can I get info, how to make required changes to get software compiling and running on s390x? For example, some software requires CPU-specific assembler code. I can not get some code to compile correctly:

https://github.com/wekan/wekan/wiki/s390x

Re: PostgreSQL on S390x

#8

Post by opencl » Fri, Nov 24, 2023, 12:48 AM UTC

maximilianburke wrote: post #5

heelix wrote: post #4

Earlier quoted context omitted.

Honestly, it just works. I can do a docker image that runs on aarch64, amd64, and s390x. For the SpringBoot apps - the hardware is rock solid and far more important, cheaper and under provisioned than the other 'standard' compute for those who have piles of legacy systems. OpenShift on zSeries is not a lot different than Intel based boxes.

Yeah, that all makes sense. Is it just big financial instututions that doing this? I can't go to IBM Cloud and kick off some S390x VMs, can I?

You can indeed get S390X VMs from IBM cloud, either running z/OS or Linux:

https://cloud.ibm.com/docs/vpc?topic=vpc-vs-profiles&interfa...

Re: PostgreSQL on S390x

#9

Post by xet7 » Fri, Nov 24, 2023, 12:49 AM UTC

maximilianburke wrote: post #5

heelix wrote: post #4

Earlier quoted context omitted.

Honestly, it just works. I can do a docker image that runs on aarch64, amd64, and s390x. For the SpringBoot apps - the hardware is rock solid and far more important, cheaper and under provisioned than the other 'standard' compute for those who have piles of legacy systems. OpenShift on zSeries is not a lot different than Intel based boxes.

Yeah, that all makes sense. Is it just big financial instututions that doing this? I can't go to IBM Cloud and kick off some S390x VMs, can I?

Open Source maintainers can ask for

a) ssh access to s390x VM

b) web console access where it's possible to create and remove VMs, for example 2 VMs, 8 GB RAM per VM

With some distro like RHEL, SUSE, Ubuntu. One mainframe runs very many VMs. All access is monitored.

Re: PostgreSQL on S390x

#10

Post by andrewstuart » Fri, Nov 24, 2023, 12:50 AM UTC

I'd be interested to see performance relative to Intel machines.