| Table of Contents | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Gallery of screenshots
| Gallery |
|---|
...
PostgreSQL installation
Surf to http https://www.postgresql.org/ and download the installer for the
latest release. For new , MS Windows users we recommend the "One click installer".
After launching this installer you have to follow these installation screens.
We recommend to keep the standard installation path.
Unlike a local file system with data filed, PostgreSQL always requires
log-in credentials. Remember to store these credentials well in a safe place.
You are the DBA (DataBase Administrator) of your local PostgreSQL database.
If you use the local PostgreSQL only as sandbox for learning how to work with
PostgreSQL, or as a cache for temporary project data, storing log-in credentials
in a function may be a convenient approach. For Matlab users a suggestion is to
save the credentials in a special function to automatic reuse. Of course this
is not recommened if you will use the local PostgreSQL for storing sensitive information.
| Code Block |
|---|
function [user,pass]=pg_credentials
user = 'postgres';
pass = 'MyP@$$word';
|
best use the Interactive installer by EDB.
If you already have a database installed and want to migrate to a newer version, please follow the steps described on https://www.postgresql.org/docs/9/migration.html.
The installer will prompt you several times. Take notice of the screen that prompts you for selection of components. Uncheck pgAdmin4. Install this as separate installer.
Proceed with with the installation of PostgreSQL. and choose spatial extension. After installing the base application Stack Builder will popup to install additional software. Select Spatial Extensions and select PostGIS.
It is not necessary to check Create spatial database.
To work with PostgreSQL/PostGIS there are several user interfaces. pgAdmin being one of them with a very active developer community. Every other month a new version is made available. That is the reason to install pgAdmin seperate from the PostgreSQL installation (to overcome the fact that if you want to update pgAdmin you end up with two versions..... ). pgAdmin can be found at https://www.pgadmin.org/download/pgadmin-4-windows/ (pick the latest). You can now procedd with installing PostGIS.