Getting started with PostGIS - Installation

The first part of a 4 part series on getting started with PostGIS. In this video I show you how to install a local version of the PostgreSQL database and the PostGIS extension for spatial data on your computer. I also show you how to enable PostGIS for a specific database and verify that it is active.

[ThePeterfrancon]

Thank you for your tutorials Mike. Your style is just perfect! You are teaching me so much.

[jinfeizhu]

Thank you so much!!! Life saver!! You are amazing! (Who is watching this even in 2021 :)

[thepurpleenigma]

Thanks so much for this tutorial... I was struggling for several hours getting my spatial DB in qgis to import directly to postgresql ... Finally your tutorial got me there. Just one note. In pgadmin 11, the user must write the extension SQL script as follows:
CREATE EXTENSION postgis SCHEMA yourschemaname

In other words the schema you want to connect your qgis to needs to be explicitly stated.

Hope this helps others that watch this using a newer version of pgadmin

[СергійБєляков]

Thanx! It was my first PostgreSQL experience!) Feeling excited!

[miladmoradi]

hey man you are perfect

please share more videos on all the subjects of GIS programming

[DutGi]

awesome! thank you for the great content

[neo]

12:30 Got error when loading the extension: ERROR: could not load library "C:/Program The specified procedure could not be found.

Solution: copy "libeay32.dll" and "ssleay32.dll" from C:\Program Files\PostgreSQL\10\bin\postgisgui, then paste both to C:\Program Files\PostgreSQL\10\bin

[ilanabensignor]

hello, can we use PgAdmin 3 instead . I have the fatal error " PgAdmin 4 could not be contacted " and tried to fix with several methods but it did not work.Thank you

[TafaNoori]

I can not add the postgis Extension, and I get the error below.





ERROR: FEHLER: konnte Bibliothek »C:/Program nicht laden: unknown error 126

[mrdibbs]

Hi Mike, thanks for the great video -- I'm planning on following through with the whole series! First question (of hopefully not too many...) I followed all these steps except I went for the newest version of postgresql (11 I think). My pgadmin 4 opens through my web browser, as opposed to a standalone app. Is that normal?

[MrMAYrichard]

Thanks Mike I'm at lesson 1 but find that i've loaded version 3.5 of pgadmin 4. Can you tell me how to upgrade this - seems i get an intervention which claims to be chrome but is rejected by my security software.
I'm finding your delivery and explanation very clear and concise
Thanks again
Richard UK

[HeroAlfa]

please complete this tutorial Course - kindly it's deserve to be full playlist

[kerrykilian]

There is no PostGis under Spatial Extensions

[norm]

Hi Mike, maybe you have already fixed it: with a better microphone the videos will be much easier consumable.

[septimusseverus]

if theres more than just like a sub i could give to u i would my friend, THANK U