Yes, I would like to receive information about new products, current offers and news about PostgreSQL via e-mail on a regular basis. Weitere Informationen finden Sie in der Datenschutzerklärung. Ich kann diese Zustimmung jederzeit widerrufen. Ja, ich möchte regelmäßig Informationen über neue Produkte, aktuelle Angebote und Neuigkeiten rund ums Thema PostgreSQL per E-Mail erhalten. In case you need support or have any questions, get in touch with the friendly folks at Cybertec. Afterwordįor folks who want to upgrade PostGIS and GEOS one after the other, just utilize postgis_extensions_upgrade() on the database level after you build and install PostGIS. Isn’t that strange? No, because we didn’t change the PostGIS version. But wait – we didn’t even upgrade PostGIS on the database level. I suggest re-running the test-query from the beginning to see the real difference. Unfortunately, calling postgis_full_version does not tell the whole truth and does not guarantee that GEOS 3.11.0 is indeed utilized by PostGIS. PostGIS assessment – final check to assess upgrade completionĭid the upgrade succeed? Let’s quickly check this via psql. Extensions -Ĭontinue by compiling PostGIS. PostGIS is now configured for x86_64-pc-linux-gnu The extensions section indicates this fact and disables SFCGAL support. You might have noticed that I didn’t install build requirements for SFCGAL. The upcoming listing only contains a subset of the information provided. This results in a configuration message summarizing the upcoming build action, which I recommend you briefly look through. Next, download and extract the PostGIS source tar and configure the build. Libprotobuf-c-dev protobuf-c-compiler libxml2-dev libproj-dev \ $> sudo apt-get install postgresql-server-dev-14 gcc libxml2 xsltproc \ At this point I recommend taking a look at Chapter 2.2.2 of the PostGIS online documentation and subsequently assess your system to identify needed libraries and tools. The server in this example already runs PostgreSQL and therefore provides some of the needed dependencies. Installing PostGIS from source – 3rd step to upgrade GEOS with Ubuntuīuild requirements must first be installed to the system. Second, download and extract the latest source tar from the GEOS website – and finally, build and install GEOS.Īgain, cross-check the geos-configuration with geos-config. $> sudo apt-get install cmake clang libgeos-devĬontinue by assessing the current geos-configuration with geos-config to confirm the basis. Installing GEOS from source – 2nd step to upgrade GEOS with Ubuntuįirst, install the necessary build requirements. Let’s get our hands dirty and build GEOS from scratch. For clarification – it’s not sufficient to update GEOS alone, PostGIS must also be rebuilt against the required GEOS. This implies building GEOS from source, or switching to another distribution channel-respective repository. Unfortunately, Ubuntu does not serve GEOS versions later than 3.8.0 through default repositories for 20.04. Postgis_demo=# select postgis_full_version() Here are the 3 steps to do that: Assess existing libraries – 1st step to upgrade GEOS with UbuntuĪs a reminder – to quickly assess which libraries have been installed in the system and particular database, execute the following commands from your psql console or preferred database client. Postgis_demo=# SELECT ST_AsText(ST_ReducePrecision('POINT(1.412 19.323)', 0.1)) ĮRROR: Precision reduction requires GEOS-3.9 or higher Her system seems to be equipped with GEOS 3.8.0. Unfortunately, this function requires at least GEOS 3.9.0. She wants to test ST_ReducePrecision ( ), a spatial function introduced in PostGIS 3.1.0. Here’s our scenario:Ī customer runs a PostgreSQL 14.5 database with PostGIS 3.2.3 installed under Ubuntu 20.04.4 LTS. Let’s see how to get the latest PostGIS libraries. In our example, we’ll upgrade GEOS with Ubuntu. Unfortunately, not all repositories serve PostGIS with the latest libraries. Since PostGIS’ functionality stack relies heavily on these libraries, downloading current library versions is unavoidable you want to use the latest stunning spatial features. Today we’ll talk about upgrading related libraries such as GEOS or GDAL. Many blog posts deal with installing or upgrading PostGIS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |