![]() Name | default_version | installed_version | comment Postgres=# select * from pg_available_extensions where name like 'postgis%' PostgreSQL kindly provides a view containing all available extensions to verify this. This implies that PostGIS must be registered as an extension within PostgreSQL’s ecosystem. PostGIS must be enabled within each database separately. Sudo apt-get install postgresql-13-postgis-3=3.1.1+dfsg-1.pgdg20.04+1 postgresql-13-postgis-3-scripts=3.1.1+dfsg-1.pgdg20.04+1īy executing apt list –-installed again, we can confirm our successful PostGIS 3 installation on Ubuntu. If this version string is not provided, the latest PostGIS version will be installed by default.įor demonstration purposes, let’s install PostGIS 3.1.1 by parameterizing the version string as follows: The version table now includes minor PostGIS version strings too, which can be handed over to apt-get install, in order to choose one particular PostGIS version. $ apt-cache policy postgresql-12-postgis-3 postgresql-12-postgis-3-scripts So, let’s execute apt-cache policy for postgresql-12 to see and understand the difference: $ apt-cache policy postgresql-13-postgis-3 postgresql-13-postgis-3-scriptsįrom the output, we realize the repository used does not provide PostGIS 3.0 packages for PostgreSQL 13. So how is it possible to install not the latest PostGIS 3.1 version, but PostGIS 3.0, instead? As an interim step, let’s output the packages’ version table first. The listing does not include packages for all minor PostGIS versions. Postgresql-13-postgis-3-scripts - Geographic objects support for PostgreSQL 13 - SQL scripts Postgresql-13-postgis-3-dbgsym - debug symbols for postgresql-13-postgis-3 Postgresql-13-postgis-3 - Geographic objects support for PostgreSQL 13 Postgresql-13-postgis-2.5-scripts - Geographic objects support for PostgreSQL 13 - SQL scripts Postgresql-13-postgis-2.5-dbgsym - debug symbols for postgresql-13-postgis-2.5 ![]() Postgresql-13-postgis-2.5 - Geographic objects support for PostgreSQL 13 Now let’s verify that our main apt-repository contains the necessary packages, by utilizing apt-cache search. The support matrix suggests installing PostGIS packages 3.0 or 3.1 on top of PostgreSQL 13. The table below displays a relevant excerpt of this matrix: PostgreSQL version Together with this version string and the PostGIS support matrix we can ensure that our PostGIS version of interest is finally supported. ![]() Postgresql/focal-pgdg,now 13+225.pgdg20.04+1 all įrom the console’s output, we can confirm that both server and client have been installed in version 13.2.1. Postgresql-contrib/focal-pgdg,now 13+225.pgdg20.04+1 all Postgresql-common/focal-pgdg,now 225.pgdg20.04+1 all Postgresql-client-common/focal-pgdg,now 225.pgdg20.04+1 all ![]() $ sudo apt list -installed | grep postgresql Let’s assume you followed Hans’ blog post (see link above) and installed PostgreSQL 13 on Ubuntu.īy utilizing apt list –installed, we can quickly list installed packages related to PostgreSQL. Let’s fix that up right now by following these steps to implement PostGIS setup: He consciously avoided any discussion of how to deal with our beloved PostGIS extension. In one of his last blogposts, our CEO Hans-Jürgen Schönig explained how to set up PostgreSQL on Ubuntu. Postgis ubuntu PostGIS setup with Ubuntu 20.04.2
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |