search

powa-team / powa-archivist

powa-archivist: the powa PostgreSQL extension
http://powa.readthedocs.io/
PostgreSQL License
51 stars 20 forks source link

Install problem pg_stat_kcache, pg_qualstats #17

Closed MBourgetMauger closed 5 years ago

MBourgetMauger commented 5 years ago

Hi, install of pg_qualstats et pg_stat_kcache get those error :

You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.u dossier de ce type make: *** Aucune règle pour fabriquer la cible « /usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk ». Arrêt.

after installing libpq-dev i still get an error :

Makefile:23: /usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk: Aucun fichier ou dossier de ce type make: *** Aucune règle pour fabriquer la cible « /usr/lib/postgresql/9.6/lib/pgxs/src/makefiles/pgxs.mk ». Arrêt.

my data directory is /var/lib/PostgreSQL/9.6/main my conf file is in /etc/ostgresql/9.6/main/ extension files are in /home/pgsqlextensions/ i guess i forgot an options with the "make" command. someone got an idea to my problem ?

Thanks. Maxime Bourget-Mauger.

rjuju commented 5 years ago

Hi,

pg_qualstats and pg_stat_kcache are server-side extension, so you need to install postgresql-server-dev-9.6 (since you seem to be using pg 9.6) to be able to compile them, not libpq-dev.

Please tell me if you hit further problems after installing this package.

MBourgetMauger commented 5 years ago

Perfect, it resolves my problem. i will keep you inform if i got an other error. Thanks.

MBourgetMauger commented 5 years ago

Everything goes fine, Extension are now installed. Thanks for your help.