PostgreSQL extension Novice here.
So I am trying to install PGroonga on Windows 10 for PostgreSQL 11(already installed) The instructions it telling me to extract the downloaded PGroonga package. And I need to specify PostgreSQL folder as extract target folder as show below.
If you installed installer version PostgreSQL,
C:\Program Files\PostgreSQL\%POSTGRESQL_VERSION%
is the extract target folder.
If you installed zip version PostgreSQL,
%POSTGRESQL_ZIP_EXTRACTED_FOLDER%\pgsql
is the extract target folder. I installed my PostgreSQL using the installer version however,I am unable to find this folder on my PostgreSQL and therefore can’t install the extension. Any help will be highly appreciated . The extracted pGroonga file has bin, etc, include, lib, share folder. While my installed pg11 also has bin etc include init lib and share folder. Extracting this file here will update the files which I think is not good. I have however copied the files to respective folder but I still get an error when.
CREATE EXTENSION pgroonga;