How can I inistall pgRouting on PostgreSQL using yum

Highlighted
Level 2 Adventurer

How can I inistall pgRouting on PostgreSQL using yum

Hi,

Does someone know how to install pgRouting on PostgreSQL?

I have tried with PostgreSQL10.

I have tried using:
sudo yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rp...

and:
sudo yum install http://mirror.sfo12.us.leaseweb.net/epel/7/x86_64/Packages/e/epel-release-7-12.noarch.rpm

But after running:
sudo sudo yum install pgrouting_10

I get this error:

---
...
Running transaction check
Running transaction test


Transaction check error:
file /usr/pgsql-10/lib/liblwgeom.so from install of postgis25_10-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis23_10-2.3.7-1 .rhel7.x86_64
file /usr/pgsql-10/share/extension/address_standardizer.control from install of postgis25_10-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis23_10-2.3.7-1.rhel7.x86_64
file /usr/pgsql-10/share/extension/address_standardizer.sql from install of postgis25_10-2.5.3-7.rhel7.x86_64 conflicts with file from pack age postgis23_10-2.3.7-1.rhel7.x86_64
file /usr/pgsql-10/share/extension/address_standardizer_data_us.control from install of postgis25_10-2.5.3-7.rhel7.x86_64 conflicts with fi le from package postgis23_10-2.3.7-1.rhel7.x86_64
file /usr/pgsql-10/share/extension/address_standardizer_data_us.sql from install of postgis25_10-2.5.3-7.rhel7.x86_64 conflicts with file f rom package postgis23_10-2.3.7-1.rhel7.x86_64
file /usr/pgsql-10/share/extension/postgis.control from install of postgis25_10-2.5.3-7.rhel7.x86_64 conflicts with file from package postg is23_10-2.3.7-1.rhel7.x86_64
file /usr/pgsql-10/share/extension/postgis_sfcgal.control from install of postgis25_10-2.5.3-7.rhel7.x86_64 conflicts with file from packag e postgis23_10-2.3.7-1.rhel7.x86_64
file /usr/pgsql-10/share/extension/postgis_tiger_geocoder.control from install of postgis25_10-2.5.3-7.rhel7.x86_64 conflicts with file fro m package postgis23_10-2.3.7-1.rhel7.x86_64
file /usr/pgsql-10/share/extension/postgis_topology.control from install of postgis25_10-2.5.3-7.rhel7.x86_64 conflicts with file from pack age postgis23_10-2.3.7-1.rhel7.x86_64

Error Summary
-------------

---

If I run the query:
select * from pg_available_extensions;

I don't get any entry for pgRouting.

Thanks by advance for any indication.

Kind Regards

 

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

5 REPLIES 5
Highlighted
EDB Team Member

Re: How can I inistall pgRouting on PostgreSQL using yum

Hello Ludwigh, 

 

Hope you are doing good. 

 

Could you please follow below steps. 

 

1. Install pgdg10 repository if you are using PG10. 

CMD: yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rp...

 

2. Since pgrouting needed postgis extension. Please Install postgis package

CMD: FOR PG10:  yum install postgis25_10

 

3. Install pgrouting package. 

CMD: FOR PG10: yum install pgrouting_10

 

4. On Successful installations above, You will see below two files.

/usr/pgsql-10/share/extension/postgis.control

/usr/pgsql-10/share/extension/pgrouting.control

 

5. Login to Database and create postgis and pgrouting extensions.

postgres=# create extension postgis;

CREATE EXTENSION

postgres=# create extension pgrouting;

CREATE EXTENSION

 

5. Check extensions by queriying "select * from pg_available_extensions;"  

 

Please let us know if you face any issues. 

 

Regards

Siva.

Highlighted
Level 2 Adventurer

Re: How can I inistall pgRouting on PostgreSQL using yum

Hi Siva,

Thanks for your feedback.

But when I try to install PostGIS, I get this error:

sudo yum install postgis25_10

error:

---
[postgres@oel764-pg95-s2 ~]$ sudo yum install postgis25_10
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package postgis25_10.x86_64 0:2.5.3-7.rhel7 will be installed
--> Processing Dependency: geos38 >= 3.8.0 for package: postgis25_10-2.5.3-7.rhel7.x86_64
--> Processing Dependency: gdal30-libs >= 3.0.4 for package: postgis25_10-2.5.3-7.rhel7.x86_64
--> Processing Dependency: xerces-c for package: postgis25_10-2.5.3-7.rhel7.x86_64
...
---

Any other suggestions?

Kind Regards

Highlighted
EDB Team Member

Re: How can I inistall pgRouting on PostgreSQL using yum

Hi Ludwigh,

It looks like you have not pasted all the yum logs. We don't see any errors in the logs that you have shared.

 

Could you please share the complete logs. Meanwhile, check whether the package is installed or not using the following command.

 

yum list installed postgis25_10

Highlighted
Level 2 Adventurer

Re: How can I inistall pgRouting on PostgreSQL using yum

Hi,

 

Yes, indeed I didnt post enough content from the log.

After issuing:

yum list installed postgis25_10

 

I get this kind of errors:

 

---
Transaction check error:
file /usr/pgsql-9.5/lib/address_standardizer.so from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with
file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/lib/liblwgeom.so from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/lib/postgis-2.4.so from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/lib/postgis_topology-2.4.so from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/lib/rtpostgis-2.4.so from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/share/extension/address_standardizer.control from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/share/extension/address_standardizer_data_us.control from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/share/extension/address_standardizer_data_us.sql from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/share/extension/postgis.control from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/share/extension/postgis_sfcgal.control from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/share/extension/postgis_tiger_geocoder.control from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
file /usr/pgsql-9.5/share/extension/postgis_topology.control from install of postgis25_95-2.5.3-7.rhel7.x86_64 conflicts with file from package postgis24_95-2.4.8-7.rhel7.x86_64
---

 

Any other idea?

 

Kind Regards

 

 

Highlighted
EDB Team Member

Re: How can I inistall pgRouting on PostgreSQL using yum

Hi Team,

From the errors, we can see that the postgis version is getting picked up for Postgres 9.5. It seems to be an issue with the Postgres repo file where the repo for version 10 is not enabled. Could you please share the Postgres repo file and also let us know how many Postgres clusters are running on the server ("ps -ef | grep postgres" output will be able to confirm us).

 

--Ankit Shukla

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks