Thread: BUG #15735: postgis extension missing
The following bug has been logged on the website: Bug reference: 15735 Logged by: ramakrishnan r Email address: prakash.ramakrishnan.ap@nielsen.com PostgreSQL version: 11.2 Operating system: Red Hat Enterprise Linux Server release 7.3 (Maipo Description: Hi Team, Am trying to install postgis in community edition getting below error please do the needful. -bash-4.2$ ./psql -p 5439 psql (11.2) Type "help" for help. postgres=# create extension postgis; ERROR: could not open extension control file "/usr/pgsql-11/share/extension/postgis.control": No such file or directory postgres=# postgres=#
On Thu, Apr 4, 2019 at 6:00 AM PG Bug reporting form <noreply@postgresql.org> wrote:
Bug reference: 15735
Email address: prakash.ramakrishnan.ap@nielsen.com
PostgreSQL version: 11.2
Operating system: Red Hat Enterprise Linux Server release 7.3 (Maipo
Hi Team,
Am trying to install postgis in community edition getting below error please
do the needful.
-bash-4.2$ ./psql -p 5439
psql (11.2)
Type "help" for help.
postgres=# create extension postgis;
ERROR: could not open extension control file
"/usr/pgsql-11/share/extension/postgis.control": No such file or directory
Have you installed PostGIS in your RedHat server? https://postgis.net/install/. The binary needs to be installed before installing the extension.
Yes, it's done. Already installed postgis but not able to create the extension.
On Thu, Apr 4, 2019, 22:58 bricklen <bricklen@gmail.com> wrote:
On Thu, Apr 4, 2019 at 6:00 AM PG Bug reporting form <noreply@postgresql.org> wrote:Bug reference: 15735
Email address: prakash.ramakrishnan.ap@nielsen.com
PostgreSQL version: 11.2
Operating system: Red Hat Enterprise Linux Server release 7.3 (Maipo
Hi Team,
Am trying to install postgis in community edition getting below error please
do the needful.
-bash-4.2$ ./psql -p 5439
psql (11.2)
Type "help" for help.
postgres=# create extension postgis;
ERROR: could not open extension control file
"/usr/pgsql-11/share/extension/postgis.control": No such file or directoryHave you installed PostGIS in your RedHat server? https://postgis.net/install/. The binary needs to be installed before installing the extension.
Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> writes: >>> postgres=# create extension postgis; >>> ERROR: could not open extension control file >>> "/usr/pgsql-11/share/extension/postgis.control": No such file or directory > Yes, it's done. Already installed postgis but not able to create the > extension. Well, it's not there in the installation you're using. I speculate that you are using PGDG server RPMs but installed a Postgis RPM that's meant to go with Red Hat's postgresql RPMs. The file layouts are different between the two sets of RPMs, so mix-and-match won't work. regards, tom lane
Ok, I'll check it out.
On Fri, Apr 5, 2019, 01:05 Tom Lane <tgl@sss.pgh.pa.us> wrote:
Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> writes:
>>> postgres=# create extension postgis;
>>> ERROR: could not open extension control file
>>> "/usr/pgsql-11/share/extension/postgis.control": No such file or directory
> Yes, it's done. Already installed postgis but not able to create the
> extension.
Well, it's not there in the installation you're using. I speculate
that you are using PGDG server RPMs but installed a Postgis RPM that's
meant to go with Red Hat's postgresql RPMs. The file layouts are
different between the two sets of RPMs, so mix-and-match won't work.
regards, tom lane