RE: GDAL dependencies during PostGIS upgrade
Removing shouldn’t be a problem as I never install those. I suspect it contains the commandline tools, not something postgresql needs to run. Those probably get installed in the system bin instead of the postgresql bin, which is why you can have only one of them. From: Nikhil Shetty Sent: Tuesday, February 20, 2024 11:33 PM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: GDAL dependencies during PostGIS upgrade Hi, I tired installing the single package but still the same error yum install -y postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64.rpm Last metadata expiration check: 0:01:18 ago on Wed 21 Feb 2024 02:51:19 AM UTC. Dependencies resolved. == PackageArchitecture Version Repository Size == Installing: postgis33_15-clientx86_64 3.3.5-1PGDG.rhel8 @commandline289 k Transaction Summary == Install 1 Package Total size: 289 k Installed size: 1.4 M Downloading Packages: Running transaction check Transaction check succeeded. Running transaction test Error: Transaction test error: file /usr/lib/.build-id/b6/89201f4430759c8544cd168dc6ba3e24f7d912 from install of postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64 conflicts with file from package postgis33_13-client-3.3.5-1PGDG.rhel8.x86_64 Alternatively just remove the postgis_33_13_client -- Will this create a problem with the existing installation of PostGIS?. I am asking because we are just installing the new packages for now and we will do the actual postgres upgrade during a downtime window Thanks, Nikhil On Tue, Feb 20, 2024 at 11:30 PM Regina Obe mailto:l...@pcorp.us> > wrote: I’m guessing you can’t have both clients installed. Not sure what is in the client package. What if you don’t do yum install -y postgis_33_15* But instead just yum install -y postgis_33_15 I’m guessing whatever that client is, they probably get installed in the same place, so you only need one of them. Alternatively just remove the postgis_33_13_client From: Nikhil Shetty mailto:nikhil.db...@gmail.com> > Sent: Tuesday, February 20, 2024 12:07 PM To: Regina Obe mailto:l...@pcorp.us> > Cc: PostGIS Users Discussion mailto:postgis-users@lists.osgeo.org> > Subject: Re: GDAL dependencies during PostGIS upgrade Hi Regina, I upgraded the existing PostGIS 3.1.2 to 3.3.5 on PG13 but now when I am trying to install PostGIS 3.3.5 for PG15 , I am getting below error Error: Transaction test error: file /usr/lib/.build-id/b6/89201f4430759c8544cd168dc6ba3e24f7d912 from install of postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64 conflicts with file from package postgis33_13-client-3.3.5-1PGDG.rhel8.x86_64 Do you know how we can resolve this ? Complete install o/p yum install -y postgis33_15* Last metadata expiration check: 0:01:21 ago on Tue 20 Feb 2024 05:01:03 PM UTC. Dependencies resolved. == PackageArchitecture Version Repository Size == Installing: postgis33_15 x86_64 3.3.5-1PGDG.rhel8 @commandline4.8 M postgis33_15-clientx86_64 3.3.5-1PGDG.rhel8 @commandline289 k
Re: GDAL dependencies during PostGIS upgrade
Hi, I tired installing the single package but still the same error yum install -y postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64.rpm > Last metadata expiration check: 0:01:18 ago on Wed 21 Feb 2024 02:51:19 AM > UTC. > Dependencies resolved. > > == > PackageArchitecture > Version > Repository Size > > == > Installing: > postgis33_15-clientx86_64 > 3.3.5-1PGDG.rhel8 > @commandline289 k > Transaction Summary > > == > Install 1 Package > Total size: 289 k > Installed size: 1.4 M > Downloading Packages: > Running transaction check > Transaction check succeeded. > Running transaction test > Error: Transaction test error: > file /usr/lib/.build-id/b6/89201f4430759c8544cd168dc6ba3e24f7d912 from > install of postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64 conflicts with file > from package postgis33_13-client-3.3.5-1PGDG.rhel8.x86_64 Alternatively just remove the postgis_33_13_client -- Will this create a problem with the existing installation of PostGIS?. I am asking because we are just installing the new packages for now and we will do the actual postgres upgrade during a downtime window Thanks, Nikhil On Tue, Feb 20, 2024 at 11:30 PM Regina Obe wrote: > I’m guessing you can’t have both clients installed. Not sure what is in > the client package. > > > > What if you don’t do > > > > yum install -y postgis_33_15* > > > > But instead just > > > > yum install -y postgis_33_15 > > > > I’m guessing whatever that client is, they probably get installed in the > same place, so you only need one of them. > > > > Alternatively just remove the postgis_33_13_client > > > > *From:* Nikhil Shetty > *Sent:* Tuesday, February 20, 2024 12:07 PM > *To:* Regina Obe > *Cc:* PostGIS Users Discussion > *Subject:* Re: GDAL dependencies during PostGIS upgrade > > > > Hi Regina, > > > > I upgraded the existing PostGIS 3.1.2 to 3.3.5 on PG13 but now when I am > trying to install PostGIS 3.3.5 for PG15 , I am getting below error > > > > Error: Transaction test error: > > file /usr/lib/.build-id/b6/89201f4430759c8544cd168dc6ba3e24f7d912 from > install of postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64 conflicts with file > from package postgis33_13-client-3.3.5-1PGDG.rhel8.x86_64 > > > > Do you know how we can resolve this ? > > > > > > Complete install o/p > > > > yum install -y postgis33_15* > Last metadata expiration check: 0:01:21 ago on Tue 20 Feb 2024 05:01:03 PM > UTC. > Dependencies resolved. > > == > PackageArchitecture > Version > Repository Size > > == > Installing: > postgis33_15 x86_64 > 3.3.5-1PGDG.rhel8 > @commandline4.8 M > postgis33_15-clientx86_64 > 3.3.5-1PGDG.rhel8 > @commandline289 k > postgis33_15-devel x86_64 > 3.3.5-1PGDG.rhel8 > @commandline8.3 k > postgis33_15-utils x86_64 > 3.3.5-1PGDG.rhel8 > @commandline 44 k > Transaction Summary > >
RE: GDAL dependencies during PostGIS upgrade
I’m guessing you can’t have both clients installed. Not sure what is in the client package. What if you don’t do yum install -y postgis_33_15* But instead just yum install -y postgis_33_15 I’m guessing whatever that client is, they probably get installed in the same place, so you only need one of them. Alternatively just remove the postgis_33_13_client From: Nikhil Shetty Sent: Tuesday, February 20, 2024 12:07 PM To: Regina Obe Cc: PostGIS Users Discussion Subject: Re: GDAL dependencies during PostGIS upgrade Hi Regina, I upgraded the existing PostGIS 3.1.2 to 3.3.5 on PG13 but now when I am trying to install PostGIS 3.3.5 for PG15 , I am getting below error Error: Transaction test error: file /usr/lib/.build-id/b6/89201f4430759c8544cd168dc6ba3e24f7d912 from install of postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64 conflicts with file from package postgis33_13-client-3.3.5-1PGDG.rhel8.x86_64 Do you know how we can resolve this ? Complete install o/p yum install -y postgis33_15* Last metadata expiration check: 0:01:21 ago on Tue 20 Feb 2024 05:01:03 PM UTC. Dependencies resolved. == PackageArchitecture Version Repository Size == Installing: postgis33_15 x86_64 3.3.5-1PGDG.rhel8 @commandline4.8 M postgis33_15-clientx86_64 3.3.5-1PGDG.rhel8 @commandline289 k postgis33_15-devel x86_64 3.3.5-1PGDG.rhel8 @commandline8.3 k postgis33_15-utils x86_64 3.3.5-1PGDG.rhel8 @commandline 44 k Transaction Summary == Install 4 Packages Total size: 5.1 M Installed size: 45 M Downloading Packages: Running transaction check Transaction check succeeded. Running transaction test Error: Transaction test error: file /usr/lib/.build-id/b6/89201f4430759c8544cd168dc6ba3e24f7d912 from install of postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64 conflicts with file from package postgis33_13-client-3.3.5-1PGDG.rhel8.x86_64 Thanks, Nikhil On Fri, Feb 16, 2024 at 11:16 AM Nikhil Shetty mailto:nikhil.db...@gmail.com> > wrote: Hi Regina, We are upgrading from PG 13 3.1.2 to PG 15 3.3.5 I forget if pg_upgrade checks the old .so to see if it can still load it or if it only checks if the new .so it is expecting in the new cluster is still available. pg_upgrade is checking in the PG13 lib whether the .so file exists or not. If it does check, I’d try upgrading to a newer PostGIS on your older cluster, doesn’t need to be the same, just one where the gdals are compatible. We might have to go with this approach because it checks the .so file in old version Error: pg_dump: error: query failed: ERROR: could not access file "$libdir/postgis-3": No such file or directory pg_dump: detail: Query was: EXECUTE dumpFunc('23873') Missing .so files: -0-root@host:/usr/pgsql-13/lib # ls -l /usr/pgsql-13/lib/postgis* ls: cannot access '/usr/pgsql-13/lib/postgis*': No such file or directory -2-root@host:/usr/pgsql-13/lib # ls -l /usr/pgsql-15/lib/postgis* /usr/pgsql-15/lib/postgis-3.so /usr/pgsql-15/lib/postgis_raster-3.so /usr/pgsql-15/lib/postgis_sfcgal-3.so /usr/pgsql-15/lib/postgis_topology-3.so Thanks, Nikhil On Fri, Feb 16, 2024 at 10:53 AM Regina Obe mailto:l...@pcorp.us> > wrote: Nikhil, Which version of PostgreSQL are you upgrading from. I forget if pg_upgrade checks the old .so to see if it can still load it or if it only checks if the new .so it is expecting in the new cluster is still available. If it doesn’t check the old to try to
Re: GDAL dependencies during PostGIS upgrade
Hi Regina, I upgraded the existing PostGIS 3.1.2 to 3.3.5 on PG13 but now when I am trying to install PostGIS 3.3.5 for PG15 , I am getting below error Error: Transaction test error: file /usr/lib/.build-id/b6/89201f4430759c8544cd168dc6ba3e24f7d912 from install of postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64 conflicts with file from package postgis33_13-client-3.3.5-1PGDG.rhel8.x86_64 Do you know how we can resolve this ? Complete install o/p yum install -y postgis33_15* > Last metadata expiration check: 0:01:21 ago on Tue 20 Feb 2024 05:01:03 PM > UTC. > Dependencies resolved. > > == > PackageArchitecture > Version > Repository Size > > == > Installing: > postgis33_15 x86_64 > 3.3.5-1PGDG.rhel8 > @commandline4.8 M > postgis33_15-clientx86_64 > 3.3.5-1PGDG.rhel8 > @commandline289 k > postgis33_15-devel x86_64 > 3.3.5-1PGDG.rhel8 > @commandline8.3 k > postgis33_15-utils x86_64 > 3.3.5-1PGDG.rhel8 > @commandline 44 k > Transaction Summary > > == > Install 4 Packages > Total size: 5.1 M > Installed size: 45 M > Downloading Packages: > Running transaction check > Transaction check succeeded. > Running transaction test > Error: Transaction test error: > file /usr/lib/.build-id/b6/89201f4430759c8544cd168dc6ba3e24f7d912 from > install of postgis33_15-client-3.3.5-1PGDG.rhel8.x86_64 conflicts with file > from package postgis33_13-client-3.3.5-1PGDG.rhel8.x86_64 Thanks, Nikhil On Fri, Feb 16, 2024 at 11:16 AM Nikhil Shetty wrote: > Hi Regina, > > We are upgrading from PG 13 3.1.2 to PG 15 3.3.5 > > I forget if pg_upgrade checks the old .so to see if it can still load it >> or if it only checks if the new .so it is expecting in the new cluster is >> still available. > > pg_upgrade is checking in the PG13 lib whether the .so file exists or not. > > If it does check, I’d try upgrading to a newer PostGIS on your older >> cluster, doesn’t need to be the same, just one where the gdals are >> compatible. > > We might have to go with this approach because it checks the .so file in > old version > > > Error: > > pg_dump: error: query failed: ERROR: could not access file > "$libdir/postgis-3": No such file or directory > > pg_dump: detail: Query was: EXECUTE dumpFunc('23873') > > > > Missing .so files: > > > -0-root@host:/usr/pgsql-13/lib # ls -l /usr/pgsql-13/lib/postgis* > > ls: cannot access '/usr/pgsql-13/lib/postgis*': No such file or directory > > > -2-root@host:/usr/pgsql-13/lib # ls -l /usr/pgsql-15/lib/postgis* > > /usr/pgsql-15/lib/postgis-3.so > > /usr/pgsql-15/lib/postgis_raster-3.so > > /usr/pgsql-15/lib/postgis_sfcgal-3.so > > /usr/pgsql-15/lib/postgis_topology-3.so > > > Thanks, > Nikhil > > On Fri, Feb 16, 2024 at 10:53 AM Regina Obe wrote: > >> Nikhil, >> >> >> >> Which version of PostgreSQL are you upgrading from. >> >> >> >> I forget if pg_upgrade checks the old .so to see if it can still load it >> or if it only checks if the new .so it is expecting in the new cluster is >> still available. >> >> >> >> If it doesn’t check the old to try to load the lib, dropping >> postgis-3.1.2 should work just fine. >> >> Since 3.0, the .so file didn’t change, so pg_upgrading from say a PG 13 >> 3.1.2 to a PG 15 3.3.5 should work just fine. >> >> >> >> If it does check, I’d try upgrading to a newer PostGIS on your older >> cluster, doesn’t need to be the same, just one where the gdals are >> compatible. >> >> >> >> *From:* Nikhil Shetty >> *Sent:* Thursday, February 15, 2024 11:37 PM >> *To:* PostGIS Users Discussion >> *Subject:* GDAL dependencies during PostGIS upgrade >> >> >> >> Hi Team, >> >> >> >> We are planning to upgrade postgres to 15 and postgis from 3.1.2 to 3.3.5. >> >> >> >> While