How to alter the path for Postgres looking for extensions? : <p>I installed Postgres on a Windows machine, downloaded the binary installer for PostGIS and installed it. I only have one version of Postgres, so there is no messing up possible. </p>

<p>Installing PostGIS using the binary installer is straight forward and you cannot mess up the installation directory either. it has to go into the Postgres directory.</p>

<p>Now, when I want to create the PostGIS extension I am getting the following error:</p>

<pre><code>ERROR:  could not open extension control file "C:/APPS/POSTGR~1/pg96/../pg96/share/postgresql/extension/postgis.control": No such file or directory
********** Error **********

ERROR: could not open extension control file "C:/APPS/POSTGR~1/pg96/../pg96/share/postgresql/extension/postgis.control": No such file or directory
SQL state: 58P01
</code></pre>

<p>Though when I go into the directory <code>C:\APPS\PostgreSQL\pg96\share\extension</code> then I do have a <code>postgis.control</code> file present.</p>

<p>How do I get the extension to work? I checked the content of the zipped PostGIS binaries and it looks like as if the structure is well preserved and all files are copied into the appropriate directories during the install process via the binary installer.</p>
