how to create this extension for postgresql manual

[kingfsen]

My company has one postgresql product，I have the username and password, can I use it to create pg_prometheus。I don't want to create myself postgresql with docker。I want to use sql type to create this extension. how can I do it?

[Knudian]

Hello.

I faced the same problem as you in my company, while trying it in a "production ready environment".

Here is how I solved the issue :

• Step 1 : get access to your postgresql host instance through, with a "root" rights users (Ubuntu world : a sudoer).
• Step 2 : Download the lastest release (v0.2.1), and unzip it,
• Step 3 : Compile it : cd /path/to/archive/ && make install
• Step 4 : Run it : ./path/to/archive/pg_prometheus
• Step 5 :

Edit postgresql.conf to include the pg_prometheus extension:
shared_preload_libraries = 'pg_prometheus'

• Step 6 : You may have to restart your psql service
• Step 7 : In the psql cli CREATE EXTENSION IF NOT EXISTS pg_prometheus;.

Now you have it up and running ;)

---

All my post was made on how I remembered doing so, so there may be a mistake or two in the middle.

[niksajakovljevic]

There is installation instruction here https://github.com/timescale/pg_prometheus#installation.
@kinfsen Did you manage to get it up and running?

[bboule]

Closing issue based on lapse in response time