search

bigsql / plprofiler

Other
79 stars 22 forks source link

Docs issues: Unable to install via pip, oscg.io not working #20

Open janklan opened 3 days ago

janklan commented 3 days ago

I'm trying to install this package in my Alpine-based Docker image:

FROM postgres:15-alpine3.18 AS plprofiler

# Install plprofiler
# See https://github.com/bigsql/plprofiler/blob/master/doc/installation.md
RUN apk add python3 py3-pip \
    && pip install --upgrade pip \
    && pip install plprofiler plprofiler-client psycopg2-binary

It looks like there at least one more step is missing to install the extension properly, because when I run CREATE EXTENSION IF NOT EXISTS "plprofiler";, I get this error back:

[0A000] ERROR: extension "plprofiler" is not available Detail: Could not open extension control file "/usr/local/share/postgresql/extension/plprofiler.control": No such file or directory. Hint: The extension must first be installed on the system where PostgreSQL is running.

Can somebody please shed some light on this?

Also, the docs talk about oscg.io which isn't working.

janklan commented 3 days ago

I saw the last activity here was 10 months ago, so I asked the same question at StackOverflow , and I hope someone not watching this repository will pick it up. If I find a solution, I'll post it on both ends; hopefully it will help someone.