How do you install PostgreSQL?

Ask Fedora
1

Hello Friends

Just being curious if you use PostgreSQL in Fedora Server, if yes, according with your experience, how it was installed by your side?. I am doing this question due the following

In the official page of PostgreSQL exists the following page:

Exists practically two approaches:

  • PostgreSQL Yum Repository
  • Included in Distribution

Where the former indicates:

Note: due to the shorter support cycle on Fedora, all supported versions of PostgreSQL are not available on this platform. We do not recommend using Fedora for server deployments

Is possible select since Fedora Server 41 to 43 but the bold message is a concern

Where the latter indicates

Which version of PostgreSQL you get will depend on the version of the distribution:

And for example Fedora Server 41 does not appear, so is mandatory do an upgrade of the OS itself

Question

  • How do you install PostgreSQL?

Thanks for your understanding

2

I’ve moved to Podman (or you can use Docker) containers for this reason.

The distro doesn’t matter anymore, as you can deploy the same version of pgsql and it’s volume to another server. The performance should be the same.

2 Likes
3

Pretty much all server-related things I have done recently, I have done with containers and not with RPM packages. When you run an application, it may have a particular requirement for its database, and containers and tags is what allows you to satisfy these requirements independent of whatever distro you are using.

For example, depending on your needs, you can choose to run

  • docker.io/postgres:18,
  • docker.io/postgres:17-trixie,
  • docker.io/postgres:17-bookworm,
  • or even something as specific as docker.io/postgres:16.10-alpine3.22.
3 Likes
4

from this url Index of /pub/repos/yum/18/fedora/fedora-43-x86_64/ download postgresql-18{18,libs,server,contrib} and rpm -it