pg_config executable not found when using pgxnclient on Windows 7 x64

Question

I installed Python 2.7.8 and pgxn client. And I tried to run this statement from command line from the bin folder and path is setup correctly

pgxnclient install  http://api.pgxn.org/dist/pg_repack/1.2.1/pg_repack-1.2.1.zip

But I got an error pg_config executable not found.

Answer 1

Bakground: pg_config is the configuration utility provided by PostgreSQL. This utility is used by various applications.

Solution:

1. Install PostgreSQL.

2. Set the path. System Properties > Advanced

   PATH:C:\Program Files (x86)\PostgreSQL\9.4\bin\;

From this point on, any application that requires pg_config can find it here.

I suggest this method because the build is directly from the author. You can also find viable alternatives for standalone pg_config builds.

Answer 2

I had this same error, and pg_config was in my path

You can try

pgxnclient install --pg_config "c:\path\to\pg_config.exe" $extensionName

You almost definitely need to run cmd.exe as an admin