Skip to content
This repository has been archived by the owner on Aug 4, 2021. It is now read-only.

add pg_prometheus and timescaledb ,start postgresql will throw error #32

Open
FunkyYang opened this issue Jan 16, 2019 · 4 comments
Open
Assignees
Labels

Comments

@FunkyYang
Copy link

FunkyYang commented Jan 16, 2019

I use prometheus adapter for store data with timescaledb.
in my postrgresql.conf.

shared_preload_libraries ='pg_prometheus'

shared_preload_libraries ='timescaledb'

and pg_prometheus and timescaledb extension can be used
but for psql:
show shared_preload_libraries.it can be show timescaledb only
why?
some one help me?

@niksajakovljevic
Copy link
Contributor

That's weird. What's the output of: select * from pg_settings where name = 'shared_preload_libraries'
Did you restarted server after changing the config file?

What's the output of \dx in psql.

@lsxredrain
Copy link

/usr/bin/mkdir -p '/usr/local/pgsql/lib'
/usr/bin/mkdir -p '/usr/local/pgsql/share/extension'
/usr/bin/mkdir -p '/usr/local/pgsql/share/extension'
/usr/bin/install -c -m 755 pg_prometheus.so '/usr/local/pgsql/lib/pg_prometheus.so'
/usr/bin/install -c -m 644 .//pg_prometheus.control '/usr/local/pgsql/share/extension/'
/usr/bin/install -c -m 644 .//sql/pg_prometheus--0.2.sql '/usr/local/pgsql/share/extension/'
Job for postgresql.service failed because the control process exited with error code. See "systemctl status postgresql.service" and "journalctl -xe" for details.

@bboule bboule self-assigned this Sep 9, 2019
@bboule bboule added the bug label Sep 9, 2019
@bboule
Copy link

bboule commented Sep 9, 2019

@lsxredrain is this still an issue? did you happen to restart postgres after you changed your config?

@krisavi
Copy link

krisavi commented Jan 22, 2020

Isn't it more correct to use line like:
shared_preload_libraries ='pg_prometheus, timescaledb'
?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

5 participants