{"id":8809,"date":"2019-05-27T02:20:17","date_gmt":"2019-05-27T00:20:17","guid":{"rendered":"http:\/\/www.sigterritoires.fr\/?p=8809"},"modified":"2023-06-22T10:11:26","modified_gmt":"2023-06-22T08:11:26","slug":"starting-with-postgres-postgis","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/","title":{"rendered":"Starting with Postgres \/ Postgis"},"content":{"rendered":"\n<p>PostgreSQL&rsquo;s general documentation is excellent, and very abundant, but\nfor QGis users (and perhaps ArcGis users) it&rsquo;s hard to find a trivial document\nexplaining how to install Postgres and then Postgis , so as to have an operational\ndatabase in a few minutes. How to envisage the &nbsp;possibilities and functioning of the pair\nPostgis \/ QGis without going through extensive training. Of course, once this\nsuperficial trick is over, you will be able to tackle the reading of the\nofficial documentation and learn how to manage or develop with Postgres. <br>\nThis &nbsp; Article aims to: <\/p>\n\n\n\n<!--more-->\n\n\n\n<ul class=\"wp-block-list\">\n<li>&nbsp;install Postgresql and Postgis on your\ncomputer (firstly we will discuss the less difficult installation in Windows) <\/li>\n<\/ul>\n\n\n\n<p>The following article aims to: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&nbsp;give you the keys to use the PgAdmin\ninterface, the PostgreSQL management tool <\/li>\n\n\n\n<li>&nbsp;help you loading a <a href=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/shapefile-vs-geopackage\/\">shapefile<\/a> layer into your\nnew database <\/li>\n\n\n\n<li>&nbsp;load your Postgis layer in QGis <\/li>\n<\/ul>\n\n\n\n<p><strong>What is PostgreSQL?<\/strong> <\/p>\n\n\n\n<p>PostgreSQL is a relational database engine. <br>\nIt is an engine adapted to business bases, &nbsp; feature-rich and very\npowerful. The PostgreSQL BSD license allows its unrestricted use even within\nproprietary software. <br>\nFrom an architecture and functional point of view we are in the presence of an\nequivalent of Oracle. This is no longer the level of Access or SQLite. In terms\nof the volume of manageable data (Tos), &nbsp; robustness of the structure,\nmanagement of competing transactions, etc., you have all the tools and\nfunctions needed to manage a production database. <\/p>\n\n\n\n<p>Extensions and tools are available to complete the engine, in particular\nPostGis which allows the management of spatial data in a PostgreSQL database\n(management of geometries and coordinate systems). <\/p>\n\n\n\n<p><strong>PostgreSQL basics<\/strong> <strong><em>Cluster<\/em><\/strong> : (or group of servers) This is a virtual set of\nservers to which you have access. \n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"225\" height=\"300\" data-attachment-id=\"8810\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/271-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/271.png?fit=225%2C300&amp;ssl=1\" data-orig-size=\"225,300\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"271\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/271.png?fit=225%2C300&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/271.png?resize=225%2C300&#038;ssl=1\" alt=\"\" class=\"wp-image-8810\"\/><\/figure>\n\n\n\n<p><strong><em>Database:<\/em><\/strong> A database is a structured set of data (Usually,\none database is used per application). A database is, necessarily, created\nwithin a cluster. \n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"225\" height=\"300\" data-attachment-id=\"8811\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/272-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/272.png?fit=225%2C300&amp;ssl=1\" data-orig-size=\"225,300\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"272\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/272.png?fit=225%2C300&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/272.png?resize=225%2C300&#038;ssl=1\" alt=\"\" class=\"wp-image-8811\"\/><\/figure>\n\n\n\n<p>A database includes both the data and the applications that concern them\n(Triggers, extensions, &#8230;) <strong><em>Database schema<\/em><\/strong>: contains the entire structure of the database\nand allows you to create specific views of the data tables. \n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"300\" data-attachment-id=\"8812\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/273-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/273.png?fit=190%2C300&amp;ssl=1\" data-orig-size=\"190,300\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"273\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/273.png?fit=190%2C300&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/273.png?resize=190%2C300&#038;ssl=1\" alt=\"\" class=\"wp-image-8812\"\/><\/figure>\n\n\n\n<p><strong><em>Login\naccounts and functions<\/em><\/strong> :\nNot to be confused. The login account is the system account used by PostgreSQL\nprocesses. The most commonly used is <strong>postgres<\/strong> . Functions, on the other\nhand, are the way to manage access rights to databases. \n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"167\" height=\"300\" data-attachment-id=\"8813\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/274-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/274.png?fit=167%2C300&amp;ssl=1\" data-orig-size=\"167,300\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"274\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/274.png?fit=167%2C300&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/274.png?resize=167%2C300&#038;ssl=1\" alt=\"\" class=\"wp-image-8813\"\/><\/figure>\n\n\n\n<p>To finish with the basics, PostgreSQL is a <strong>client \/ server<\/strong>\napplication . The server manages the files in the database, accepts client\nconnections, and performs the operations requested by clients (requests &#8230;). The\ncustomer can take many forms. To administer PostgreSQL you have a graphical\ninterface, pgAdmin3. To work on the data (display, formatting, update) you can\ndo it with QGis. <\/p>\n\n\n\n<p><strong>How to install the latest version of PostgreSQL and\nPostgis.<\/strong> <\/p>\n\n\n\n<p>You can download the latest version installation from the following\nlink: \n\n\nChoose the version corresponding to your system:\n&nbsp;\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"222\" data-attachment-id=\"8814\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/275-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/275.png?fit=917%2C318&amp;ssl=1\" data-orig-size=\"917,318\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"275\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/275.png?fit=640%2C222&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/275.png?resize=640%2C222&#038;ssl=1\" alt=\"\" class=\"wp-image-8814\" srcset=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/275.png?w=917&amp;ssl=1 917w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/275.png?resize=300%2C104&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/275.png?resize=768%2C266&amp;ssl=1 768w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nLaunch\nthe installer: &nbsp;\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"235\" data-attachment-id=\"8815\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/276-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/276.png?fit=300%2C235&amp;ssl=1\" data-orig-size=\"300,235\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"276\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/276.png?fit=300%2C235&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/276.png?resize=300%2C235&#038;ssl=1\" alt=\"\" class=\"wp-image-8815\"\/><\/figure>\n\n\n\n<p>You will get the various settings screens. You can change the default\noptions, but if you do not have a really important reason for doing so, stay\nwithin the default option. The documentation, help and examples that you will\nfind available on the internet are always conceived for the default options. \n\nThe installation directory: \n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"237\" data-attachment-id=\"8816\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/277-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/277.png?fit=300%2C237&amp;ssl=1\" data-orig-size=\"300,237\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"277\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/277.png?fit=300%2C237&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/277.png?resize=300%2C237&#038;ssl=1\" alt=\"\" class=\"wp-image-8816\"\/><\/figure>\n\n\n\n<p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nThe\ndirectory for the data cluster: &nbsp;\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"234\" data-attachment-id=\"8817\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/278-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/278.png?fit=300%2C234&amp;ssl=1\" data-orig-size=\"300,234\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"278\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/278.png?fit=300%2C234&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/278.png?resize=300%2C234&#038;ssl=1\" alt=\"\" class=\"wp-image-8817\"\/><\/figure>\n\n\n\n<p>You can later create other clusters. \n\nYou will have to enter the password linked to\nthe postgres administrator account: &nbsp;\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"235\" data-attachment-id=\"8818\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/279-3\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/279.png?fit=300%2C235&amp;ssl=1\" data-orig-size=\"300,235\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"279\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/279.png?fit=300%2C235&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/279.png?resize=300%2C235&#038;ssl=1\" alt=\"\" class=\"wp-image-8818\"\/><\/figure>\n\n\n\n<p>Warning, in fact this covers two different notions: <br>\n\u2022 an operating system user, the one on whose account the server programs are running,\n<br>\n\u2022 the database super user. <br>\nThey may have different names and passwords, but for this installer it was\nchosen to give the same name and password. The name, which does not appear, is <strong><em>postgres.<\/em><\/strong>\n<\/p>\n\n\n\n<p>Write down this password, you will need it systematically even to\ninstall Postgis. \n\nYou will be asked to define the port of access\nto PostgreSQL: \n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"235\" data-attachment-id=\"8819\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/2710-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2710.png?fit=300%2C235&amp;ssl=1\" data-orig-size=\"300,235\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2710\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2710.png?fit=300%2C235&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2710.png?resize=300%2C235&#038;ssl=1\" alt=\"\" class=\"wp-image-8819\"\/><\/figure>\n\n\n\n<p>Leave the default port (5432). If necessary, you can reconfigure this\nparameter when you study the security of your production base. \n\nYou will have to define the language used by\nyour installation. The default option is that of your operating system. &nbsp;\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"234\" data-attachment-id=\"8820\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/2711-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2711.png?fit=300%2C234&amp;ssl=1\" data-orig-size=\"300,234\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2711\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2711.png?fit=300%2C234&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2711.png?resize=300%2C234&#038;ssl=1\" alt=\"\" class=\"wp-image-8820\"\/><\/figure>\n\n\n\n<p>The setup of the installation is finished. Click Next to run. \n\nWhen the installation is complete, the next\nscreen asks if you want to launch <strong><em>Stack Builder<\/em><\/strong> . This is the\ntool that will allow you to install the PostGis extension. Leave the box\nchecked and click <strong><em>Finish<\/em><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"234\" data-attachment-id=\"8821\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/2712-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2712.png?fit=300%2C234&amp;ssl=1\" data-orig-size=\"300,234\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2712\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2712.png?fit=300%2C234&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2712.png?resize=300%2C234&#038;ssl=1\" alt=\"\" class=\"wp-image-8821\"\/><\/figure>\n\n\n\n<p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nThe\n<strong><em>Stack Builder<\/em><\/strong> installation screen is displayed. Scroll down the\nmenu and select PostgreSQL 9.5 on port 5432 &nbsp;\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"205\" data-attachment-id=\"8822\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/2713-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2713.png?fit=300%2C205&amp;ssl=1\" data-orig-size=\"300,205\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2713\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2713.png?fit=300%2C205&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2713.png?resize=300%2C205&#038;ssl=1\" alt=\"\" class=\"wp-image-8822\"\/><\/figure>\n\n\n\n<p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nYou\nwill get the list of available extension types. Open the \u00ab\u00a0Spatial\nExtensions\u00a0\u00bb item and select the appropriate installation type for your\nsystem.\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"204\" data-attachment-id=\"8823\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/attachment\/2714\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2714.png?fit=300%2C204&amp;ssl=1\" data-orig-size=\"300,204\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2714\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2714.png?fit=300%2C204&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2714.png?resize=300%2C204&#038;ssl=1\" alt=\"\" class=\"wp-image-8823\"\/><\/figure>\n\n\n\n<p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nThe\ninstaller asks you for a folder to download the module: \n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"202\" data-attachment-id=\"8824\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/attachment\/2715\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2715.png?fit=300%2C202&amp;ssl=1\" data-orig-size=\"300,202\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2715\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2715.png?fit=300%2C202&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2715.png?resize=300%2C202&#038;ssl=1\" alt=\"\" class=\"wp-image-8824\"\/><\/figure>\n\n\n\n<p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nThe\nsetting is complete. \n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"205\" data-attachment-id=\"8825\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/attachment\/2716\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2716.png?fit=300%2C205&amp;ssl=1\" data-orig-size=\"300,205\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2716\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2716.png?fit=300%2C205&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2716.png?resize=300%2C205&#038;ssl=1\" alt=\"\" class=\"wp-image-8825\"\/><\/figure>\n\n\n\n<p>Click <strong><em>Next<\/em><\/strong> to run the installation. \n\nAccept the terms of the license. A screen asking\nyou which components to install appears. Check the \u00ab\u00a0Create Spatial\ndatabase\u00a0\u00bb box to have the installer create a blank Postgis database in\nyour cluster. &nbsp;\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"202\" data-attachment-id=\"8826\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/attachment\/2717\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2717.png?fit=300%2C202&amp;ssl=1\" data-orig-size=\"300,202\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2717\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2717.png?fit=300%2C202&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2717.png?resize=300%2C202&#038;ssl=1\" alt=\"\" class=\"wp-image-8826\"\/><\/figure>\n\n\n\n<p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nKeep\nthe default directory\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"236\" data-attachment-id=\"8827\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/attachment\/2718\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2718.png?fit=300%2C236&amp;ssl=1\" data-orig-size=\"300,236\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2718\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2718.png?fit=300%2C236&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2718.png?resize=300%2C236&#038;ssl=1\" alt=\"\" class=\"wp-image-8827\"\/><\/figure>\n\n\n\n<p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nEnter\nthe <strong><em>postgres<\/em><\/strong> password , which you defined during Postgresql\ninstallation:\n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"231\" data-attachment-id=\"8828\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/attachment\/2719\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2719.png?fit=300%2C231&amp;ssl=1\" data-orig-size=\"300,231\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2719\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2719.png?fit=300%2C231&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2719.png?resize=300%2C231&#038;ssl=1\" alt=\"\" class=\"wp-image-8828\"\/><\/figure>\n\n\n\n<p>Give your blank Postgis database a name, or\nleave the default name. \n\n\n\n<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"236\" data-attachment-id=\"8830\" data-permalink=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/starting-with-postgres-postgis\/2720-1\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2720-1.png?fit=300%2C236&amp;ssl=1\" data-orig-size=\"300,236\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2720-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2720-1.png?fit=300%2C236&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.sigterritoires.fr\/wp-content\/uploads\/2019\/05\/2720-1.png?resize=300%2C236&#038;ssl=1\" alt=\"\" class=\"wp-image-8830\"\/><\/figure>\n\n\n\n<p>You will get three questions regarding the rasters management. Answer\nYES to each of them. <\/p>\n\n\n\n<p>The installation of Postgres and Postgis on your workstation is\ncomplete. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL&rsquo;s general documentation is excellent, and very abundant, but for QGis users (and perhaps ArcGis users) it&rsquo;s hard to find a trivial document explaining how to install Postgres and then Postgis , so as to have&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"give_campaign_id":0,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1260],"tags":[],"class_list":["post-8809","post","type-post","status-publish","format-standard","hentry","category-non-classe-en"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p6XU0A-2i5","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/8809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/comments?post=8809"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/posts\/8809\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=8809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/categories?post=8809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/tags?post=8809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}