[postgis-users] How to install the latest PostGIS (3.0 or very latest) on CentOS 8.1?

708 views
Skip to first unread message

/dev /local/ca

unread,
Apr 30, 2020, 3:36:18 AM4/30/20
to postgi...@lists.osgeo.org
I am attempting to following instructions to install PostGIS here (to install the latest production release of PostGIS on CentOS 8.1):


---

In the section titled:

`Red Hat / Centos / Scientific Linux`

I do not understand exactly what it is I need to do there, or if I need to do it,or how to determine if I need to do anything in that section.

---

When I run this command on my CentOS 8 system, 

`$dnf list | grep postgis30_12`

I get:

```
postgis30_12.x86_64                                  3.0.1-2.rhel8                                     pgdg12
postgis30_12-client.x86_64                           3.0.1-2.rhel8                                     pgdg12
postgis30_12-devel.x86_64                            3.0.1-2.rhel8                                     pgdg12
postgis30_12-docs.x86_64                             3.0.1-2.rhel8                                     pgdg12
postgis30_12-gui.x86_64                              3.0.1-2.rhel8                                     pgdg12
postgis30_12-utils.x86_64                            3.0.1-2.rhel8                                     pgdg12
```

---

Question 1:
so therefore, is there anything in that section that I need to do?

Question 2:
After reading this section, how would I determine if I need to do anything?

Question 3:
And if so, what would that be?

---

When I run:

`create extension postgis;`

I get this error:


ERROR:  could not open extension control file "/usr/pgsql-12/share/extension/postgis.control": No such file or directory
When checking, indeed that file (postgis.control) is not there.

Question 4:
What am I missing?
---
sql>select version();`

PostgreSQL 12.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20190507 (Red Hat 8.3.1-4), 64-bit
---
OS installed was: CentOS Linux release 8.1.1911 (Core)

(not sure why it says: Red Hat 8.3.1-4 in: select version();)

---


Devrim Gündüz

unread,
Jun 3, 2020, 4:33:08 PM6/3/20
to PostGIS Users Discussion

Hi,

On Thu, 2020-04-30 at 01:35 -0600, /dev /local/ca wrote:
> so therefore, is there anything in that section that I need to do?

https://people.planetpostgresql.org/devrim/index.php?/archives/102-Installing-PostGIS-3.0-and-PostgreSQL-12-on-CentOS-8.html

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
signature.asc

Regina Obe

unread,
Jun 5, 2020, 12:13:40 PM6/5/20
to PostGIS Users Discussion
Devrim,

Thanks for the instructions, I added to this page -
https://postgis.net/install/

> so therefore, is there anything in that section that I need to do?

>
https://people.planetpostgresql.org/devrim/index.php?/archives/102-Installin
g-PostGIS-3.0-and-PostgreSQL-12-on-CentOS-8.html

I ran into a stumbling block on a fresh Centos 8.1

dnf -y config-manager --set-enabled PowerTools

Gave - "No such command: config-manager. Please use /usr/bin/dnf --help"

I had to do this beforehand -- can you add this line to the instructions
after the epel-release install.

yum install dnf-plugins-core

#It installed okay after, but when I go to do a yum update I get this error

yum update

Last metadata expiration check: 0:06:57 ago on Fri Jun 5 15:55:27 2020.
Error:
Problem: cannot install the best update candidate for package
gdal30-libs-3.0.4-3.rhel8.x86_64
- nothing provides libzstd.so.1()(64bit) needed by
gdal30-libs-3.0.4-4.rhel8.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to
use not only best candidate packages)


yum update --nobest

shows
Problem: cannot install the best update candidate for package
gdal30-libs-3.0.4-3.rhel8.x86_64
- nothing provides libzstd.so.1()(64bit) needed by
gdal30-libs-3.0.4-4.rhel8.x86_64
============================================================================
===================================================================
Package Architecture Version
Repository Size
============================================================================
===================================================================
Skipping packages with broken dependencies:
gdal30-libs x86_64
3.0.4-4.rhel8 pgdg-common 7.5
M

Transaction Summary
============================================================================
===================================================================
Skip 1 Package

Nothing to do.
Complete!


#any rate seems to have installed okay, but I assume the above will cause
issues for upgrades

testgis=# CREATE EXTENSION postgis;
CREATE EXTENSION
#testgis=# CREATE EXTENSION postgis_raster;
testgis=# SELECT postgis_full_version();



postgis_full_version

----------------------------------------------------------------------------
-------------------------------------------------------------------
-------------------------------------------------------------------
POSTGIS="3.0.1 ec2a9aa" [EXTENSION] PGSQL="120" GEOS="3.8.1-CAPI-1.13.3"
PROJ="6.3.2" GDAL="GDAL 3.0.4, released 2020/01/28" LIBXML="2.9.7" LI
BJSON="0.13.1" LIBPROTOBUF="1.3.0" WAGYU="0.4.3 (Internal)" RASTER
(1 row)

Thanks,
Regina

_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

Devrim Gündüz

unread,
Jun 5, 2020, 4:45:41 PM6/5/20
to Regina Obe, PostGIS Users Discussion

Hi Regina,

On Fri, 2020-06-05 at 12:13 -0400, Regina Obe wrote:
> I ran into a stumbling block on a fresh Centos 8.1

https://twitter.com/DevrimGunduz/status/1262711444606464000?s=20

and

https://twitter.com/DevrimGunduz/status/1268281346893516802?s=20

(this 2nd one also applies to gdal as well :( )

More details:

https://bugzilla.redhat.com/show_bug.cgi?id=1715799#c54

So, this time EPEL and CentOS both got broken badly. You need to
install libzstd package manually in CentOS 8.1
signature.asc
Reply all
Reply to author
Forward
0 new messages