add pg_prometheus and timescaledb ,start postgresql will throw error

[FunkyYang]

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]

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]

/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]

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

[krisavi]

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