Jump to content

PostgreSQL postgis: Difference between revisions

From annawiki
No edit summary
No edit summary
Line 6: Line 6:
  CREATE EXTENSION postgis;
  CREATE EXTENSION postgis;
  SELECT PostGIS_Version(); //verify install
  SELECT PostGIS_Version(); //verify install
quit;
apt install osm2pgsql //https://osm2pgsql.org/doc/install/linux.html

Revision as of 2025-08-12T14:09:59

Example for Ubuntu and osmdb

apt install postgis
psql -d xxx //xxx=any dbname of a db one can connect to
CREATE DATABASE osmdb;
\c osmdb;
CREATE EXTENSION postgis;
SELECT PostGIS_Version(); //verify install

quit;
apt install osm2pgsql //https://osm2pgsql.org/doc/install/linux.html