PostGIS 2.2, PostgreSQL 9.5 install guide
Regina Obe and Leo Hsu
- Free postgresql 9.3.x download software at UpdateStar - PostgreSQL is a powerful, open source relational database system.PostgreSQL has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity,.
- Take complete control of your contact center. Easily add remote agents, new channels, chatbots and IVR. Move your contact center to the cloud on the infrastructure that powers over half a million agents and leave behind the limitations of SaaS with Flex, the world’s only fully programmable platform.
Book in progress: pgRouting: A Practical Guide http://locatepress.com/pgrouting
After your PostgreSQL server is up and running, you’ll probably want to connect to it from your application. Here’s how to connect to PostgreSQL from popular programming languages and frameworks: PHP. To connect from PHP, make sure that it supports PostgreSQL. The version included with macOS doesn't support PostgreSQL. The best place to get the latest binaries for both PostgreSQL and PostGIS is the PostgreSQL Yum repository Refer to Installing PostGIS 3 and PostgreSQL 12 on CentOS 8 repository RPM for your distribution, download and install it. Ubuntu / Debian.
http://www.postgis.us / http://www.bostongis.com / http://www.postgresonline.com
Using RevealJS
Using RevealJS
Navigating the Slides
![Postgresql 9.2 download Postgresql 9.2 download](/uploads/1/2/6/7/126754771/758207217.png)
To toggle between full slide deck and individual, use the
ESC
key.Use
s
key to see the slide notes. These instructions apply to all the slides we'll be posting. Best experienced with Firefox or Chrome.
Where to Get it?
There are many
Covered here: http://postgis.net/install, but we'll repeat a bit.
How many people already have PostGIS installed?
We know each OS has a lot of options so if we left your favorite out, we're really sorry. We picked ones that seemed most popular, with recent versions of PostGIS and relatively easy for newbies from our purview.
Mac
Quickest and Newbie friendly http://postgresapp.com. Has PostgreSQL 9.5 and PostGIS 2.2, but as of this writing does not have SFCGAL or pgRouting or ogr_fdw.
Homebrew another popular option http://braumeister.org/formula/postgis
Latest recipes include PostgreSQL 9.5, PostGIS 2.2.1 (with sfcgal 1.2.2), pgRouting 2.1
We are starting with Mac, because we were told most real developers use Mac. We are not real developers.Windows
Downloads and instructions here: http://postgis.net/windows_downloads
- Stable version: Get from Application Stackbuilder. PostGIS 2.2 (with SFCGAL 1.2) for PostgreSQL 9.3-9.5, includes pgRouting 2.1, ogr_fdw, and pgpointcloud companion extensions.
- Bleeding Edge including with SFCGAL 3D support and PostGIS 2.3 (built for PostgreSQL 9.3-9.5) - get from Winnie, the PostGIS windows build-bot. Winnie builds a fresh pot whenever any changes in PostGIS code base. She has updates for stable releases as well.
RedHat EL, CentOS, Scientific Linux
RedHat EL, CentOS, Scientific Linux, Amazon Linux: Use PostgreSQL Yum repo: http://yum.postgresql.org
Some instructions you might find useful: An almost idiot's guide to install PostgreSQL 9.5, PostGIS 2.2 and pgRouting 2.1.0 with Yum
Base repos for EL and CentOS are often behind the times especially for older versions of EL and CentOS as far as PostgeSQL and PostGIS goes, so it's advised to use the PostgreSQL yum repo wherever possible.
Ubuntu and Debian
- PostgreSQL Apt: Instructions for Ubuntu PostgreSQL 9.5, PostGIS 2.2, pgRouting 2.1 on Ubuntu Sadly doesn't seem to include postgis_sfcgal extension.
- Ubuntu 14.04: You can also use Docker for Experimenting with PostGIS 2.2 with SFCGAL, pgRouting 2.1, PostgreSQL 9.5, and ogrfdw. https://github.com/vpicavet/docker-pggis.
- For the full loaded experience (PostGIS plus all the OpenSource GIS you can eat). Try OSGeo-Live VM or Bootable DVD (works on Windows, Mac, Linux), but hefty - http://live.osgeo.org/en/download.html
Create a database
Create a database if you don't have one already. No postgres database does not count, and please don't install PostGIS in postgres.
If your distribution did not come with raster or running with lower than PostgreSQL 9.1, Sorry, can't use
CREATE EXTENSION
. Go hereExtensions: Spatially enable your database
Connect to your database first and then run the below commands
https://igzjb.over-blog.com/2020/11/hp-photosmart-essentials-35-download.html. Other extensions commonly used or packaged with PostGIS
We'll be using the basic postgis extension as well as postgis_tiger_geocoder. Best macos app for openng downloades.
sfcgal is available in PostGIS 2.1, but its not packaged as an extension (you have to run the sfcgal.sql script) and was considered experimental so most distributions don't carry it. address_standardizer was a separate extension as a fork of PAGC on sourceforge. In PostGIS 2.2 both address_standardizer and sfcgal are packaged and installable with
CREATE EXTENSION
.No Extensions: Spatially enable your database
Postgresql 9.3 Download Mac High Sierra
Connect to your database first preferably using psql and then run the following scripts which are usually located in /share/contrib/postgis-2.1 of your postgresql install.
For tiger geocoder, run the correct scripts Tiger geocoder install without extensions.
We'll be using the basic postgis extension as well as postgis_tiger_geocoder in this session. pgRouting we'll be using in the next session.
Activex controls download for mac. In PostGIS 2.2 both address_standardizer and postgis_sfcgal are packaged and installable with
CREATE EXTENSION
.Verify install of PostGIS
Download Postgresql 9.4
If you have sfcgal extension installed as well, then your output will look like: