{"id":15547,"date":"2023-10-02T07:12:21","date_gmt":"2023-10-01T22:12:21","guid":{"rendered":"https:\/\/lab4ict.com\/system\/?p=15547"},"modified":"2023-10-02T07:16:52","modified_gmt":"2023-10-01T22:16:52","slug":"postgis%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%99%e3%82%8b%ef%bc%81%ef%bc%88ubuntu-server-22-04%ef%bc%89","status":"publish","type":"post","link":"https:\/\/lab4ict.com\/system\/archives\/15547","title":{"rendered":"PostGIS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\uff01\uff08Ubuntu Server 22.04\uff09"},"content":{"rendered":"<p>Ubuntu Server 22.04\u306b\u3001PostGIS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<br \/>\n<!--more--><\/p>\n<h2>\u4f7f\u7528\u3059\u308b\u74b0\u5883\u3092\u78ba\u8a8d\u3059\u308b\uff01<\/h2>\n<p>\u4f7f\u7528\u3059\u308b\u74b0\u5883\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n$ hostnamectl\r\n Static hostname: vmsgis11\r\n       Icon name: computer-vm\r\n         Chassis: vm\r\n      Machine ID: e18a27fbe8ac4dbcb89641f30b005d2e\r\n         Boot ID: 87db6f30005f4714b4b29aeb109bdc4d\r\n  Virtualization: oracle\r\nOperating System: Ubuntu 22.04.3 LTS              \r\n          Kernel: Linux 5.15.0-84-generic\r\n    Architecture: x86-64\r\n Hardware Vendor: innotek GmbH\r\n  Hardware Model: VirtualBox\r\n<\/pre>\n<h2>PostgreSQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\uff01<\/h2>\n<p>\u6a19\u6e96\u306e\u30ea\u30dd\u30b8\u30c8\u30ea\u304b\u3089PostgreSQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n$ sudo apt install postgresql\r\nReading package lists... Done\r\nBuilding dependency tree... Done\r\nReading state information... Done\r\nThe following additional packages will be installed:\r\n  libcommon-sense-perl libjson-perl libjson-xs-perl libllvm14 libpq5 libsensors-config libsensors5\r\n  libtypes-serialiser-perl postgresql-14 postgresql-client-14 postgresql-client-common postgresql-common ssl-cert\r\n  sysstat\r\nSuggested packages:\r\n  lm-sensors postgresql-doc postgresql-doc-14 isag\r\nThe following NEW packages will be installed:\r\n  libcommon-sense-perl libjson-perl libjson-xs-perl libllvm14 libpq5 libsensors-config libsensors5\r\n  libtypes-serialiser-perl postgresql postgresql-14 postgresql-client-14 postgresql-client-common postgresql-common\r\n  ssl-cert sysstat\r\n0 upgraded, 15 newly installed, 0 to remove and 3 not upgraded.\r\nNeed to get 42.4 MB of archives.\r\nAfter this operation, 161 MB of additional disk space will be used.\r\n...\r\n<\/pre>\n<h2>PostGIS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\uff01<\/h2>\n<p>\u6a19\u6e96\u306e\u30ea\u30dd\u30b8\u30c8\u30ea\u304b\u3089PostGIS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n$ sudo apt install postgis\r\nReading package lists... Done\r\nBuilding dependency tree... Done\r\nReading state information... Done\r\nThe following additional packages will be installed:\r\n  fontconfig-config fonts-dejavu-core gdal-data libaec0 libaom3 libarmadillo10 libarpack2 libblas3 libblosc1\r\n  libboost-serialization1.74.0 libcfitsio9 libcharls2 libdav1d5 libde265-0 libdeflate0 libfontconfig1 libfreexl1\r\n  libfyba0 libgdal30 libgeos-c1v5 libgeos3.10.2 libgeotiff5 libgfortran5 libgif7 libgmpxx4ldbl libhdf4-0-alt\r\n  libhdf5-103-1 libhdf5-hl-100 libheif1 libjbig0 libjpeg-turbo8 libjpeg8 libkmlbase1 libkmldom1 libkmlengine1\r\n  liblapack3 liblcms2-2 libltdl7 libminizip1 libmysqlclient21 libnetcdf19 libodbc2 libodbcinst2 libogdi4.1\r\n  libopenjp2-7 libpoppler118 libproj22 libprotobuf-c1 libqhull-r8.0 libquadmath0 librttopo1 libsfcgal1 libsnappy1v5\r\n  libspatialite7 libsuperlu5 libsz2 libtiff5 liburiparser1 libwebp7 libx265-199 libxerces-c3.2 mysql-common\r\n  poppler-data postgis-doc postgresql-14-postgis-3 postgresql-14-postgis-3-scripts proj-bin proj-data unixodbc-common\r\nSuggested packages:\r\n  geotiff-bin gdal-bin libgeotiff-epsg libhdf4-doc libhdf4-alt-dev hdf4-tools liblcms2-utils odbc-postgresql tdsodbc\r\n  ogdi-bin poppler-utils ghostscript fonts-japanese-mincho | fonts-ipafont-mincho fonts-japanese-gothic\r\n  | fonts-ipafont-gothic fonts-arphic-ukai fonts-arphic-uming fonts-nanum\r\nThe following NEW packages will be installed:\r\n  fontconfig-config fonts-dejavu-core gdal-data libaec0 libaom3 libarmadillo10 libarpack2 libblas3 libblosc1\r\n  libboost-serialization1.74.0 libcfitsio9 libcharls2 libdav1d5 libde265-0 libdeflate0 libfontconfig1 libfreexl1\r\n  libfyba0 libgdal30 libgeos-c1v5 libgeos3.10.2 libgeotiff5 libgfortran5 libgif7 libgmpxx4ldbl libhdf4-0-alt\r\n  libhdf5-103-1 libhdf5-hl-100 libheif1 libjbig0 libjpeg-turbo8 libjpeg8 libkmlbase1 libkmldom1 libkmlengine1\r\n  liblapack3 liblcms2-2 libltdl7 libminizip1 libmysqlclient21 libnetcdf19 libodbc2 libodbcinst2 libogdi4.1\r\n  libopenjp2-7 libpoppler118 libproj22 libprotobuf-c1 libqhull-r8.0 libquadmath0 librttopo1 libsfcgal1 libsnappy1v5\r\n  libspatialite7 libsuperlu5 libsz2 libtiff5 liburiparser1 libwebp7 libx265-199 libxerces-c3.2 mysql-common\r\n  poppler-data postgis postgis-doc postgresql-14-postgis-3 postgresql-14-postgis-3-scripts proj-bin proj-data\r\n  unixodbc-common\r\n0 upgraded, 70 newly installed, 0 to remove and 3 not upgraded.\r\nNeed to get 52.5 MB of archives.\r\nAfter this operation, 215 MB of additional disk space will be used.\r\n...\r\n<\/pre>\n<h2>\u304a\u308f\u308a\u306b<\/h2>\n<p>Ubuntu Server 22.04\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u6a19\u6e96\u306e\u30ea\u30dd\u30b8\u30c8\u30ea\u304b\u3089\u5bb9\u6613\u306bPostGIS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<h2>\u95a2\u9023\u8a18\u4e8b<\/h2>\n<div class=\"sc_getpost\"><a class=\"clearfix\" href=\"https:\/\/lab4ict.com\/system\/archives\/10355\" ><div class=\"sc_getpost_thumb post-box-thumbnail__wrap\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODdhAQABAPAAAN3d3QAAACwAAAAAAQABAAACAkQBADs=\" width=\"150\" height=\"150\" alt=\"\u3010\u8a18\u4e8b\u4e00\u89a7\u3011 \u30b5\u30fc\u30d0\u74b0\u5883\u3092\u69cb\u7bc9\u3059\u308b\uff01\" loading=\"lazy\" data-src=\"https:\/\/lab4ict.com\/system\/wp-content\/uploads\/2022\/11\/eyecatch_serverapps_01-150x150.png\" class=\"lazyload\"><\/div><div class=\"title\">\u3010\u8a18\u4e8b\u4e00\u89a7\u3011 \u30b5\u30fc\u30d0\u74b0\u5883\u3092\u69cb\u7bc9\u3059\u308b\uff01<\/div><div class=\"substr\">\u5404\u7a2e\u30b5\u30fc\u30d0\u74b0\u5883\u3092\u69cb\u7bc9\u3059\u308b\u305f\u3081\u306e\u8a18\u4e8b\u4e00\u89a7\u3092\u63b2\u8f09\u3057\u307e\u3059\u3002...<\/div><\/a><\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ubuntu Server 22.04\u306b\u3001PostGIS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":1,"featured_media":14987,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[232],"tags":[1263,51,359,679],"class_list":["post-15547","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server-applications","tag-postgis","tag-ubuntu","tag-ubuntu-server","tag-ubuntu-server-22-04"],"_links":{"self":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/15547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/comments?post=15547"}],"version-history":[{"count":3,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/15547\/revisions"}],"predecessor-version":[{"id":15550,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/15547\/revisions\/15550"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/media\/14987"}],"wp:attachment":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/media?parent=15547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/categories?post=15547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/tags?post=15547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}