public inbox for [email protected]  
help / color / mirror / Atom feed
PostgreSQL 16 and PostGIS
3+ messages / 2 participants
[nested] [flat]

* PostgreSQL 16 and PostGIS
@ 2023-11-13 07:00 Simon Connah <[email protected]>
  2023-11-13 07:10 ` RE: PostgreSQL 16 and PostGIS Regina Obe <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Simon Connah @ 2023-11-13 07:00 UTC (permalink / raw)
  To: [email protected] <[email protected]>

Hi,

I originally posted in the PostgreSQL novice list that I had installed PostgreSQL 16 on Rocky Linux 9 using this method:

https://www.postgresql.org/download/linux/redhat/

and it works perfectly. But when I try and install PostGIS I ended up getting this error:

[root@139-162-197-226 simon]# dnf update
Last metadata expiration check: 1:11:27 ago on Mon 13 Nov 2023 05:02:27 AM UTC.
Dependencies resolved.
Nothing to do.
Complete!
[root@139-162-197-226 simon]# dnf install postgis34_16
Last metadata expiration check: 1:11:40 ago on Mon 13 Nov 2023 05:02:27 AM UTC.
Error:
 Problem: package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 requires gdal36-libs >= 3.6.3, but none of the providers can be installed
  - package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 requires libgdal.so.32()(64bit), but none of the providers can be installed
  - conflicting requests
  - nothing provides libqhull_r.so.7()(64bit) needed by gdal36-libs-3.6.4-4PGDG.rhel9.x86_64
  - nothing provides libqhull_r.so.7()(64bit) needed by gdal36-libs-3.6.4-5PGDG.rhel9.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

Is there any fix to this at all?

Thank you.

Simon.

Attachments:

  [application/pgp-signature] signature.asc (249B, 2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: PostgreSQL 16 and PostGIS
  2023-11-13 07:00 PostgreSQL 16 and PostGIS Simon Connah <[email protected]>
@ 2023-11-13 07:10 ` Regina Obe <[email protected]>
  2023-11-13 07:29   ` RE: PostgreSQL 16 and PostGIS Simon Connah <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Regina Obe @ 2023-11-13 07:10 UTC (permalink / raw)
  To: 'Simon Connah' <[email protected]>; [email protected]

> Hi,
> 
> I originally posted in the PostgreSQL novice list that I had installed PostgreSQL
> 16 on Rocky Linux 9 using this method:
> 
> https://www.postgresql.org/download/linux/redhat/
> 
> and it works perfectly. But when I try and install PostGIS I ended up getting this
> error:
> 
> [root@139-162-197-226 simon]# dnf update Last metadata expiration check:
> 1:11:27 ago on Mon 13 Nov 2023 05:02:27 AM UTC.
> Dependencies resolved.
> Nothing to do.
> Complete!
> [root@139-162-197-226 simon]# dnf install postgis34_16 Last metadata
> expiration check: 1:11:40 ago on Mon 13 Nov 2023 05:02:27 AM UTC.
> Error:
>  Problem: package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 requires gdal36-
> libs >= 3.6.3, but none of the providers can be installed
>   - package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 requires
> libgdal.so.32()(64bit), but none of the providers can be installed
>   - conflicting requests
>   - nothing provides libqhull_r.so.7()(64bit) needed by gdal36-libs-3.6.4-
> 4PGDG.rhel9.x86_64
>   - nothing provides libqhull_r.so.7()(64bit) needed by gdal36-libs-3.6.4-
> 5PGDG.rhel9.x86_64
> (try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use
> not only best candidate packages)
> 
> Is there any fix to this at all?
> 
> Thank you.
> 
> Simon.

I think you might be missing the 

crb enable

step that Devrim mentioned in an email thread.

FWIW, I've updated the Yum instructions on postgis.net t o include that.

https://postgis.net/documentation/getting_started/install_red_hat/

Let me know if all that works for you or if I missed anything.
Those worked for me, but I was testing with Rocky8 








^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: PostgreSQL 16 and PostGIS
  2023-11-13 07:00 PostgreSQL 16 and PostGIS Simon Connah <[email protected]>
  2023-11-13 07:10 ` RE: PostgreSQL 16 and PostGIS Regina Obe <[email protected]>
@ 2023-11-13 07:29   ` Simon Connah <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Simon Connah @ 2023-11-13 07:29 UTC (permalink / raw)
  To: Regina Obe <[email protected]>; +Cc: [email protected]


> > Hi,
> 

> > I originally posted in the PostgreSQL novice list that I had installed PostgreSQL
> > 16 on Rocky Linux 9 using this method:
> > 

> > https://www.postgresql.org/download/linux/redhat/
> > 

> > and it works perfectly. But when I try and install PostGIS I ended up getting this
> > error:
> > 

> > [root@139-162-197-226 simon]# dnf update Last metadata expiration check:
> > 1:11:27 ago on Mon 13 Nov 2023 05:02:27 AM UTC.
> > Dependencies resolved.
> > Nothing to do.
> > Complete!
> > [root@139-162-197-226 simon]# dnf install postgis34_16 Last metadata
> > expiration check: 1:11:40 ago on Mon 13 Nov 2023 05:02:27 AM UTC.
> > Error:
> > Problem: package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 requires gdal36-
> > libs >= 3.6.3, but none of the providers can be installed
> > - package postgis34_16-3.4.0-1PGDG.rhel9.x86_64 requires
> > libgdal.so.32()(64bit), but none of the providers can be installed
> > - conflicting requests
> > - nothing provides libqhull_r.so.7()(64bit) needed by gdal36-libs-3.6.4-
> > 4PGDG.rhel9.x86_64
> > - nothing provides libqhull_r.so.7()(64bit) needed by gdal36-libs-3.6.4-
> > 5PGDG.rhel9.x86_64
> > (try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use
> > not only best candidate packages)
> > 

> > Is there any fix to this at all?
> > 

> > Thank you.
> > 

> > Simon.
> 

> 

> I think you might be missing the
> 

> crb enable
> 

> step that Devrim mentioned in an email thread.
> 

> FWIW, I've updated the Yum instructions on postgis.net t o include that.
> 

> https://postgis.net/documentation/getting_started/install_red_hat/
> 

> Let me know if all that works for you or if I missed anything.
> Those worked for me, but I was testing with Rocky8
> 


Hi,

I got it installed but had to change a command to get it to work.

I used the following:

dnf -y install epel-release
dnf config-manager --enable crb
crb enable
dnf -y install postgis34_16
systemctl restart postgresql-16

Simon.

Attachments:

  [application/pgp-signature] signature.asc (249B, 2-signature.asc)
  download

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2023-11-13 07:29 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-13 07:00 PostgreSQL 16 and PostGIS Simon Connah <[email protected]>
2023-11-13 07:10 ` Regina Obe <[email protected]>
2023-11-13 07:29   ` Simon Connah <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox