4

I'm a noob to linux and pi so may just be missing the obvious but it appears the latest version available for the pi is 11.x which does not support generated columns. I am in the process of porting an app from windows which relies on generated columns so I need version 12.

2
  • perhaps in raspbian.raspberrypi.org/raspbian/pool/main/p currently there appears to be a 'postgresql-13' directory with specific options available in it
    – jimmont
    Dec 30 '20 at 10:25
  • Following up on what Ingo said, I was in the same situation where I needed PGSQL >= 12.0, and I found this helpful guide on how to compile pgsql version 12 from source. Aug 19 at 20:59
4

In addition to the options presented by Ingo, there is also a PostgreSQL Docker image with ARM support:
https://github.com/docker-library/postgres
https://hub.docker.com/_/postgres/

This will probably be easier than (cross-)compiling it from source yourself, and running services like Postgres in a Docker container is a pretty standard practice these days.

1
  • This is probably the best way to go. As far as I have found it's the only option to run Postgres 13. Beware the limited amount of RAM on an RPI though - if OS upgrades results in more RAM being consumed by the OS, it could render the Docker container difficult to start up. Jun 4 at 10:03
2

The postgresql project has binaries available for Debian using a repository with adding an entry in /etc/apt/sources.list as you can see at Postgresql - Linux downloads (Debian). But you will also find there that it is only

available on the following architectures:

  • amd64
  • i386
  • ppc64el

armhf for the Raspberry Pi isn't part of the list so you are lost to compile it from source but I'm afraid that will take hours on a RasPi even on a RPi 4B with 4GB ram.

You can also compile on a more powerful computer with an intel processor (amd64) for the Raspberry Pi (armhf). This is called cross compiling but need some knowledge about compiling and isn't an easy task for a beginner. You could ask google how to do it and if running into problems just ask here.

1
  • Thanks for that. I wonder if I can compile on a x86 linux mint laptop for a specified architecture?
    – Edward
    Feb 1 '20 at 22:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.