Re: [Qgis-user] Error: ERROR: could not access file "$libdir/postgis-2.4": No such file or directory - After installing QGIS 3.10 LTR

2020-05-29 Thread chris hermansen
Marie and list;

On Fri, May 29, 2020 at 7:09 AM Marie Anna Baovola 
wrote:

> Thank you for replying,
>
> In fact, I can install the PostgreSQL/PostGIS, but I couldn't install
> QGIS. I have those error while executing the "sudo apt-get install qgis
> qgis-plugin-grass":
>
> ***
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> The following packages were automatically installed and are no longer
> required:
>   liblwgeom-2.4-0 libprotobuf-c1
> Use 'sudo apt autoremove' to remove them.
> The following additional packages will be installed:
>   gdal-bin gdal-data grass-core libcfitsio5 libgdal26 libgeotiff5
> libjs-leaflet liblaszip8 libpdal-base9 libpdal-plugin-faux
>   libpdal-plugin-icebridge libpdal-plugin-pgpointcloud
> libpdal-plugin-python libpdal-plugin-sqlite libpdal-plugins libpdal-util9
> libqca-qt5-2
>   libqca-qt5-2-plugins libqgis-3d3.10.5 libqgis-analysis3.10.5
> libqgis-app3.10.5 libqgis-core3.10.5 libqgis-customwidgets libqgis-gui3.10.5
>   libqgis-native3.10.5 libqgis-server3.10.5 libqgisgrass7-3.10.5
> libqgispython3.10.5 libqt53danimation5 libqt53dcore5 libqt53dextras5
>   libqt53dinput5 libqt53dlogic5 libqt53dquickscene2d5 libqt53drender5
> libqt5concurrent5 libqt5designercomponents5 libqt5keychain1
>   libqt5quickwidgets5 libqt5serialport5 libqwt-qt5-6 libspatialindex4v5
> libsqlite3-mod-spatialite python3-future python3-gdal python3-owslib
>   python3-plotly python3-pyproj python3-pyqt5.qsci python3-pyqt5.qtsql
> python3-qgis python3-qgis-common qgis-common qgis-plugin-grass-common
>   qgis-provider-grass qgis-providers qgis-providers-common
> qt3d-assimpsceneimport-plugin qt3d-defaultgeometryloader-plugin
>   qt3d-gltfsceneio-plugin qt3d-scene2d-plugin qt5-assistant
> qttools5-dev-tools
> Suggested packages:
>   libgdal-grass grass-dev grass-gui e00compr avce00 gpsbabel gpstrans
> python3-rpy2 python3-termcolor geotiff-bin libgeotiff-epsg
>   python-future-doc owslib-doc ipython3 python3-pandas python3-scipy
> otb-qgis saga qt5-doc
>
> *The following packages will be REMOVED:  libgdal20 postgis
> postgresql-10-postgis-2.4 postgresql-9.5-postgis-2.4 python-gdal*
> The following NEW packages will be installed:
>   grass-core libcfitsio5 libgdal26 libgeotiff5 libjs-leaflet liblaszip8
> libpdal-base9 libpdal-plugin-faux libpdal-plugin-icebridge
>   libpdal-plugin-pgpointcloud libpdal-plugin-python libpdal-plugin-sqlite
> libpdal-plugins libpdal-util9 libqca-qt5-2 libqca-qt5-2-plugins
>   libqgis-3d3.10.5 libqgis-analysis3.10.5 libqgis-app3.10.5
> libqgis-core3.10.5 libqgis-customwidgets libqgis-gui3.10.5
> libqgis-native3.10.5
>   libqgis-server3.10.5 libqgisgrass7-3.10.5 libqgispython3.10.5
> libqt53danimation5 libqt53dcore5 libqt53dextras5 libqt53dinput5
> libqt53dlogic5
>   libqt53dquickscene2d5 libqt53drender5 libqt5concurrent5
> libqt5designercomponents5 libqt5keychain1 libqt5quickwidgets5
> libqt5serialport5
>   libqwt-qt5-6 libspatialindex4v5 libsqlite3-mod-spatialite python3-future
> python3-gdal python3-owslib python3-plotly python3-pyproj
>   python3-pyqt5.qsci python3-pyqt5.qtsql python3-qgis python3-qgis-common
> qgis qgis-common qgis-plugin-grass qgis-plugin-grass-common
>   qgis-provider-grass qgis-providers qgis-providers-common
> qt3d-assimpsceneimport-plugin qt3d-defaultgeometryloader-plugin
>   qt3d-gltfsceneio-plugin qt3d-scene2d-plugin qt5-assistant
> qttools5-dev-tools
> The following packages will be upgraded:
>   gdal-bin gdal-data
> 2 upgraded, 63 newly installed, 5 to remove and 456 not upgraded.
> Need to get 120 MB of archives.
> After this operation, 372 MB of additional disk space will be used.
> Do you want to continue? [Y/n]
>

There aren't any error messages presented in the output above.

When I log into an Ubuntu 18.04 server that I use, I see the version of
QGIS provided with the system is 2.18.17 and the version of PostGIS is
2.4.3.

Your apt output shows that you're trying to install QGIS version 3.10.5,
which tells us that you have added a new non-Ubuntu repository that
contains that newer version.

The message about removing libgdal20 postgis postgresql-10-postgis-2.4
postgresql-9.5-postgis-2.4 python-gdal tells us that the QGIS version you
are trying to install is not compatible with those versions of libgdal,
postgis etc.

Therefore I think you need to find a repository or set of repositories that
contains the version of QGIS that you want (3.10.5 I guess) and the other
necessary software libgdal, postgis, etc.

Look here: https://qgis.org/en/site/forusers/alldownloads.html#debian-ubuntu

You may need both https://qgis.org/ubuntu/ and
https://qgis.org/ubuntugis-ltr or possibly just the latter.


>
> I use Ubuntu 18.04. I have GDAL 2.4.2, released 2019/06/28.
>
> I've already tried all of the existed repository but no effect.
>
> Thank you for your advice.
>
> Best regards,
>
> Baovola
>
> On Sat, May 9, 2020 at 4:16 PM chris hermansen 
> wrote:
>
>> Marie Anne and list,
>>
>> On Fri, May 

Re: [Qgis-user] Error: ERROR: could not access file "$libdir/postgis-2.4": No such file or directory - After installing QGIS 3.10 LTR

2020-05-29 Thread Marie Anna Baovola
Thank you for replying,

In fact, I can install the PostgreSQL/PostGIS, but I couldn't install QGIS.
I have those error while executing the "sudo apt-get install qgis qgis-
plugin-grass":

***
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer
required:
  liblwgeom-2.4-0 libprotobuf-c1
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
  gdal-bin gdal-data grass-core libcfitsio5 libgdal26 libgeotiff5
libjs-leaflet liblaszip8 libpdal-base9 libpdal-plugin-faux
  libpdal-plugin-icebridge libpdal-plugin-pgpointcloud
libpdal-plugin-python libpdal-plugin-sqlite libpdal-plugins libpdal-util9
libqca-qt5-2
  libqca-qt5-2-plugins libqgis-3d3.10.5 libqgis-analysis3.10.5
libqgis-app3.10.5 libqgis-core3.10.5 libqgis-customwidgets libqgis-gui3.10.5
  libqgis-native3.10.5 libqgis-server3.10.5 libqgisgrass7-3.10.5
libqgispython3.10.5 libqt53danimation5 libqt53dcore5 libqt53dextras5
  libqt53dinput5 libqt53dlogic5 libqt53dquickscene2d5 libqt53drender5
libqt5concurrent5 libqt5designercomponents5 libqt5keychain1
  libqt5quickwidgets5 libqt5serialport5 libqwt-qt5-6 libspatialindex4v5
libsqlite3-mod-spatialite python3-future python3-gdal python3-owslib
  python3-plotly python3-pyproj python3-pyqt5.qsci python3-pyqt5.qtsql
python3-qgis python3-qgis-common qgis-common qgis-plugin-grass-common
  qgis-provider-grass qgis-providers qgis-providers-common
qt3d-assimpsceneimport-plugin qt3d-defaultgeometryloader-plugin
  qt3d-gltfsceneio-plugin qt3d-scene2d-plugin qt5-assistant
qttools5-dev-tools
Suggested packages:
  libgdal-grass grass-dev grass-gui e00compr avce00 gpsbabel gpstrans
python3-rpy2 python3-termcolor geotiff-bin libgeotiff-epsg
  python-future-doc owslib-doc ipython3 python3-pandas python3-scipy
otb-qgis saga qt5-doc

*The following packages will be REMOVED:  libgdal20 postgis
postgresql-10-postgis-2.4 postgresql-9.5-postgis-2.4 python-gdal*
The following NEW packages will be installed:
  grass-core libcfitsio5 libgdal26 libgeotiff5 libjs-leaflet liblaszip8
libpdal-base9 libpdal-plugin-faux libpdal-plugin-icebridge
  libpdal-plugin-pgpointcloud libpdal-plugin-python libpdal-plugin-sqlite
libpdal-plugins libpdal-util9 libqca-qt5-2 libqca-qt5-2-plugins
  libqgis-3d3.10.5 libqgis-analysis3.10.5 libqgis-app3.10.5
libqgis-core3.10.5 libqgis-customwidgets libqgis-gui3.10.5
libqgis-native3.10.5
  libqgis-server3.10.5 libqgisgrass7-3.10.5 libqgispython3.10.5
libqt53danimation5 libqt53dcore5 libqt53dextras5 libqt53dinput5
libqt53dlogic5
  libqt53dquickscene2d5 libqt53drender5 libqt5concurrent5
libqt5designercomponents5 libqt5keychain1 libqt5quickwidgets5
libqt5serialport5
  libqwt-qt5-6 libspatialindex4v5 libsqlite3-mod-spatialite python3-future
python3-gdal python3-owslib python3-plotly python3-pyproj
  python3-pyqt5.qsci python3-pyqt5.qtsql python3-qgis python3-qgis-common
qgis qgis-common qgis-plugin-grass qgis-plugin-grass-common
  qgis-provider-grass qgis-providers qgis-providers-common
qt3d-assimpsceneimport-plugin qt3d-defaultgeometryloader-plugin
  qt3d-gltfsceneio-plugin qt3d-scene2d-plugin qt5-assistant
qttools5-dev-tools
The following packages will be upgraded:
  gdal-bin gdal-data
2 upgraded, 63 newly installed, 5 to remove and 456 not upgraded.
Need to get 120 MB of archives.
After this operation, 372 MB of additional disk space will be used.
Do you want to continue? [Y/n]



I use Ubuntu 18.04. I have GDAL 2.4.2, released 2019/06/28.

I've already tried all of the existed repository but no effect.

Thank you for your advice.

Best regards,

Baovola

On Sat, May 9, 2020 at 4:16 PM chris hermansen 
wrote:

> Marie Anne and list,
>
> On Fri, May 8, 2020, 23:53 Marie Anna Baovola 
> wrote:
>
>> Hello everyone,
>>
>> Anyone could help me how to fix my error in my object, please?
>> I have installed the QGIS 3.10 and it seems that my PostgreSQL is
>> upgraded into 10.12. I use Ubuntu 18.04 bionic.
>>
>> I cannot reinstall the extension Postgis.
>>
>
>
> How did you install QGIS and PostgreSQL? With apt?
>
> You should be able to use the same tool to install postgis. For example
> something like
>
> sudo apt install postgis
>
> at the command line.
>
> If you used some other system tool to install QGIS and PostgreSQL, like
> synaptic, you can also use that to install postgis.
>
> Chris
>


-- 
BAOVOLA Marie Anna
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Error: ERROR: could not access file "$libdir/postgis-2.4": No such file or directory - After installing QGIS 3.10 LTR

2020-05-09 Thread Neil B
I find it odd that installing QGIS 3.10 would force an upgrade on
Postgresql to version 10.12. What version of Postgresql were you running
before? If it was a minor version of 10 before and it is still 10, then
that's trival. If it was previously a 9.X version then I wonder how your
data got migrated from the 9.X version to the 10 version automatically.

I'm guessing that the dependencies of gdal, proj, et cetera being brought
in for QGIS 3.10 probably forced an upgrade of the postgis version that's
causing the problem. The following steps are all run from the command line
as root. (Preface the command with sudo if required.)

Find out what versions of postgis for Postresql 10 are available/installed:
 apt list --all-versions | grep postgresql-10-postgis
The versions that are installed will have [installed]
or [installed,automatic] at the end. The entries for postgis-2.4 shouldn't
have anything at the end.

If you want to just fix the missing packages, then run
 apt install postgresql-10-postgis-2.4 postgresql-10-postgis-2.4-scripts
This should resolve your immediate problem and you can stop here.

Based on the earlier command, if postgis 2.5 shows up as being installed
and you want to upgrade to that version, there are several steps that need
to be done. The previous step of installing the postgis-2.4 packages still
needs to be done and you should have both the 2.4 and 2.5 packages
installed.

The extensions in Postgresql need to be upgraded and the following commands
only need to be done in the database(s) where the postgis extension has
been installed. All commands shown are run from the command line and using
psql to connect. Also assuming postgis was initially installed within
Postgresql using extensions.

Connect to the Postgresql cluster and the necessary database as the user
postgres.
The following command will provide a list of installed extensions.
 mydb=# \dx
If postgis does not show up in the list, stop. Make sure you're connected
to the correct database if you have multiple databases on that cluster. If
postgis shows up (and should say 2.4.X for the version) in the list then
proceed.
 mydb=# alter extension postgis update;
And run the following to update existing or get additional extensions
associated with that version of postgis.
 mydb=# select postgis_extensions_upgrade();
Repeat the above procedure for each database within the cluster that has
postgis extensions installed. Upgrading one database does not upgrade all
of the databases.

If everything was successful in the above steps, the postgis 2.4 packages
can be removed from the OS. Only do this if you have upgraded all databases
using postgis 2.4 to a newer version. Running as root from the command line:
 apt remove postgresql-10-postgis-2.4 postgresql-10-postgis-2.4-scripts

Not specific to this question but adding the following as thoughts for
longer term planning to anyone still using older versions of Postgresql and
Postgis.

It is best to upgrade from postgis version 2.4 or lower to either version
2.5 or version 3.0 sooner than later especially if you are planning a major
version upgrade of Postgresql. My experience is that you require
the scripts for the version of the postgis extension installed to actually
upgrade the extension within Postgresql to a newer version. Newer versions
(11 and 12) of Postgresql do not have packages in the repository for
postgis 2.4 which may cause problems if trying to update/upgrade the
postgis extensions post database upgrade.

Just an FYI Postgresql 9.5 and 9.6 will both have their final releases next
year. If you have no hard dependencies on the version of Postresql, and are
planning an upgrade, I would suggest going to Postgresql version 12 with
Postgis version 3. Postgresql 12's final release date is set for 14 Nov
2024 which will give you a few years of stability.

On Sat, May 9, 2020 at 12:53 AM Marie Anna Baovola 
wrote:

> Hello everyone,
>
> Anyone could help me how to fix my error in my object, please?
> I have installed the QGIS 3.10 and it seems that my PostgreSQL is upgraded
> into 10.12. I use Ubuntu 18.04 bionic.
>
> I cannot reinstall the extension Postgis.
>
> Thank you in advance for your help.
>
> Best regards,
>
>
> --
> BAOVOLA Marie Anna
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Error: ERROR: could not access file "$libdir/postgis-2.4": No such file or directory - After installing QGIS 3.10 LTR

2020-05-09 Thread Jorge Gustavo Rocha
Hi,

Can you please tell us which repositories are you using? Check "apt
policy" for qgis/postgis related packages. The very first http address
on the output is the repository you are using.

Try something like:

apt policy postgresql

apt policy postgresql-10-postgis-2.5

apt policy qgis

Maybe you are mixing repositories.

Regards,

Jorge

On 09/05/20 07:53, Marie Anna Baovola wrote:
> Hello everyone,
>
> Anyone could help me how to fix my error in my object, please?
> I have installed the QGIS 3.10 and it seems that my PostgreSQL is
> upgraded into 10.12. I use Ubuntu 18.04 bionic.
>
> I cannot reinstall the extension Postgis.
>
> Thank you in advance for your help.
>
> Best regards,
>
>
> -- 
> BAOVOLA Marie Anna
>
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-- 
Email Signature
Logo  
*Geomaster*
*Jorge Gustavo Rocha* | Software Engineer
*e:*j...@geomaster.pt | *m:*+351 910 333 888
*g:*41.54094,-8.40490 | *v: *510 906 109
*a: * Rua António Cândido Pinto, 67, 4715-400 Braga

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Error: ERROR: could not access file "$libdir/postgis-2.4": No such file or directory - After installing QGIS 3.10 LTR

2020-05-09 Thread Marie Anna Baovola
Hello everyone,

Anyone could help me how to fix my error in my object, please?
I have installed the QGIS 3.10 and it seems that my PostgreSQL is upgraded
into 10.12. I use Ubuntu 18.04 bionic.

I cannot reinstall the extension Postgis.

Thank you in advance for your help.

Best regards,


-- 
BAOVOLA Marie Anna
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user