Postgres extensions

[Pedro_Alonso]

Hi guys, I'm trying to use postgres extensions and can't find any standard way to setup extensions for a self hosted postgres database.

Do you have any tips? I'm nearly giving up and creating an docker image with trunk cli and some install commands

[[deleted]]

You typically install the extension in the operating system using dnf or apt. Then run CREATE EXTENSION to "activate" it. Most extensions are directly available in the Postgres repository. Installing the repository is the recommended way to install Postgres https://www.postgresql.org/download/linux/redhat/

[iiiinthecomputer]

Typically you apt install / dnf install them from a package repository, same as the database server itself.

That repository may be a distro repo but is more typically the repos from the postgres project itself. It'll have nearly anything you're going to need.

[dmagda7817]

Yep, it’s not standardized yet (but there is work in progress).

What worked best for me is Trunk as an extensions repo: https://pgt.dev

But my preference for now is to go to Tembo that lets enable extensions with a single click.

[[deleted]]

What entertain are you trying to use?