[postgis-tickets] [PostGIS] #3790: "ERROR: could not open extension control file" on BigSQL installation of PostgreSQL

[PostGIS]

#3790: "ERROR:  could not open extension control file" on BigSQL installation of
PostgreSQL
-----------------------------------+-------------------
 Reporter:  realityexists          |      Owner:  strk
     Type:  defect                 |     Status:  new
 Priority:  medium                 |  Milestone:
Component:  build/upgrade/install  |    Version:  2.3.x
 Keywords:                         |
-----------------------------------+-------------------
 When I run "CREATE EXTENSION postgis" on PostgreSQL 9.6.3 installed from
 the BigSQL installer (http://oscg-
 downloads.s3.amazonaws.com/packages/PostgreSQL-9.6.3-1-win64-bigsql.exe) I
 get the following error:

 '''ERROR: could not open extension control file
 "C:/PROGRA~1/POSTGR~1/9.6/pg96/../pg96/share/postgresql/extension/postgis.control":
 No such file or directory
 SQL state: 58P01'''

 I selected "C:\Program Files\PostgreSQL\9.6\pg96" as my "PostgreSQL
 directory" during installation (see #3789) and that file is actually under
 "C:\Program Files\PostgreSQL\9.6\pg96\share\extension".

 Even if I move all the extension files to the directory it's looking in I
 get another error:

 '''ERROR:  could not access file "$libdir/postgis-2.3": No such file or
 directory'''

 So it appears that the BigSQL installer uses some directory layout PostGIS
 does not support. It should either be supported or the lack of support
 should be documented on the download page and in the installer. The
 installer should detect this situation automatically and either handle it
 properly (install to the right locations) or tell the user to install from
 the EnterpriseDB installer instead (but this is not ideal, as the user may
 have done a lot with their cluster before trying to install PostGIS).

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3790>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.