Install PostgreSQL 13 on Windows 10

PostgreSQL is one of the most popular Relational Database Management System (RDBMS). It’s an open-source program that available for Windows, Mac as well as Linux system. The new PostgreSQL 13 is now available for Windows users. So in this article, I am going to install PostgreSQL 13 on Windows 10.

PostgreSQL 13 includes significant improvements to its indexing and lookup system that benefit large databases, including space savings and performance gains for indexes, faster response times for queries that use aggregates or partitions, better query planning when using enhanced statistics, and more.

Steps to Install PostgreSQL 13 on Windows 10

I will install the new PostgreSQL 13 certified by EnterpriseDB. This is the easiest way to get PostgreSQL 13 up and running on Windows 10. So let’s get started. First, download the installer from the link below.

This is the binary installer for PostgreSQL 13 for Windows 64 bit. There is no 32-bit version for this. It will download around 205 MB from the internet. You should now have a file called: postgresql-13.0-1-windows-x64.exe. Double-click the file to start the installation.

Specify the installation directory
Select the components to install
Specify the data directory
Provide a password for postgres user
Select the port number for the PostgreSQL Server
Select the locale
Installation summary

Press Next and the installation will start. When the installation finished, I recommend to run the Stack builder. We can add extension to the PostgreSQL using this Stack builder or install the ODBC driver.

Basically, we have successfully installed the latest PostgreSQL 13 on Windows 10. Below, you can see how to install some additional extensions for PostgreSQL server.

Install PostGIS 3.0 on PostgreSQL 13

Run Stack Builder from the Windows menu. Select the PostgreSQL server from the list.

Select PostGIS 3.0 Bunder under Spatial Extensions

Press Next and the PostGIS installer will open up.

Accept license agreement
Select components to install
Enter the database connection information
Create a new spatial database

Wait until the installation completes. Now, we have successfully installed PostgreSQL 13 and PostGIS 3.0 on Windows 10. Thanks for reading and see you next time.

Be the first to comment

Leave a Reply

Your email address will not be published.