You Can Try Again Using Brew Postinstall Postgresql

This tutorial serves to install PostgreSQL on windows and extension PostGIS and Pgrouting for the functions of GIS.

Before y'all tin can use PostgreSQL yous need to install it. Yous demand to go to the download folio of PostgreSQL installers on the EnterpriseDB. Click the download version link you want to install. In this tutorial, I select version 13.

A. Stepwise Installation of PostgreSQL on Windows.

Yous require ambassador privileges to install PostgreSQL on Windows.

Step 1.

Double click on the installer to get an installation wizard that guides you through the steps.

Stride 2. Click the Adjacent button

Pace iii. Specify the installation binder. A default folder is suggested by the PostgreSQL installer, choose your ain or keep it.

Click the Next button

Step 4. Select software components to install.

• PostgreSQL Server to install the PostgreSQL database server,
• pgAdmin 4 to install the PostgreSQL database GUI management tool.
• Stack Builder provides a GUI that allows you to download and install drivers that work with PostgreSQL
• Command Line Tools to install command-line tools such equally pg_restore, psql.

These allow interacting with the PostgreSQL database server using the command-line interface.

Footstep 5. Select the database directory to store the data or have the default folder.

Click the Next button to get to the side by side step:

Step half-dozen. Enter the password for the database superuser (Postgres)

PostgreSQL runs as a service in the background nether a service account named postgres. If you already created a service account with the name postgres, you lot demand to provide the password of that account in the following window.

After entering the password, you demand to retype it to confirm.

Click the Next button.

Pace seven. Enter a port number on which the PostgreSQL database server will mind. The default port of PostgreSQL is 5432. You need to brand sure that no other applications are using this port. Nosotros are using port 5433 in this tutorial yours might be unlike.

Step 8. Choose the default locale used by the PostgreSQL database. If you leave it as the default locale, PostgreSQL will utilize the operating arrangement locale.

After that click the Next push.

Footstep 9. The setup wizard will show the summary data of PostgreSQL. You need to review information technology and click the Side by side button if everything is correct. Otherwise, yous need to click the Back button to change the configuration accordingly.

Now, you lot're ready to install PostgreSQL on your computer. Click the Next button to begin installing PostgreSQL.

The installation may take a few minutes to consummate.

Step 10. Y'all can click the Finish button since PostgreSQL installation is consummate.

B. Install PostGIS using Stack Builder.

To proceed, check the box to use a Stack Builder to install PostGIS spatial extension used in GIS.

Aggrandize spatial extension, and select the version of PostGIS to install. PostGIS version may differ depending on the version of PostgreSQL you chose previously.

Click the Side by side push button

Do not bank check the Skip installation box. Click the next push to install PostGIS.

The installation will run and the following images will appear on your screen.

Click Finish to cease the installation.

C. Verify the Installation

In that location are several ways to verify the PostgreSQL installation. You can try to connect to the PostgreSQL database server from any client application e.thousand. psql and pgAdmin4.

Through the psql programme.

Become to the start of your windows organisation and blazon psql to launch the application.

Enter all the necessary information.

Server, database, port, username, and password.

To accept the default, you can press Enter.

Note that you should provide the password that you lot entered during installing the PostgreSQL.

The epitome beneath shows the necessary data.

The port we are using is port 5433 which was used in our installation of PostgreSQL 13.

Using pgAdmin 4

Using the start push button of your windows arrangement type pgAdmin and launch it. In your browser, pgAdmin volition open up with a prompt for a password. Enter the password that you created in the installation.

You should see PostgreSQL 13. Expand to see the default database postgres.

Expand extensions to see available extensions.

D. Create extensions PostGIS and pgrouting.

Step ane. Extension postgis

Expand extension in the database you are working with. In our instance, we are working on postgres database. Right click on extensions and click create and select extension.

Click on the extension. And under the proper name, type postgis, or select postgis. Click Salvage.

The extension postgis is added.

Step 2. Extension pgrouting

Repeat the previous step of creating an extension.

Type pgrouting and select save.

The extension pgrouting is added under extension in the database.

These extensions are helpful in GIS for additional functionalities. For instance, pgrouting allows calculating route from 1 characteristic to the other (eg manhole to manhole) through connecting feature( eg pipe)

Congratulation! you've successfully installed the PostgreSQL database server on your local system. And added extensions PostGIS and Pgrouting.

washingtonshmisting.blogspot.com

Source: https://gisforwaterandsanitation.wordpress.com/2021/01/07/installing-posgresql-and-its-extensions-postgis-and-pgrouting/

Share this post