I installed Posgresql version 10 (stable) through the source package (compiling manually) in the directory opt/pgv10/ .. on my OS LInux Debian Version 8.
I would like to use the HIPOPG extension 1, 2 to enable the creation of hypothetical indexes in postgresql.
I checked on document (link) you have to have the Dev package from postgresql, but I believe my installation does not have this (I think).
I tried to download the file extension .zip but can not proceed with the compilation and installation (with make and make install), because it gives the following message:
make: pg_config: Command not found
make: Nothing to be done for 'all'.
On .zip file that I downloaded has the files: HANGELOG.md hypopg – 1.0.0.sql hypopg.control hypopg_import.h META.json test typedefs.list expected hypopg.c hypopg_import.c Makefile README.md TODO.md
In tutorials on the internet, they talk to install via apt-get, but as I installed it manually I believe it will not work.
I tried to run the command:
create extension hypopg; in psql program, but gave the message below even though I put the hypopg.control files in opt/pgv10/share/postgresql/extension/
ERROR: could not access file "$ libdir / hypopg": No such file or directory
Would anyone know how to manually install an extension and if it would have to have the -dev package and how would I install that package.
Best Regards
Neto
Best Answer
THe solution was:
Best Regards Neto