BUG #15735: postgis extension missing

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:

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: