Your source of learning, Windows, Linux, Solaris, Virtualization, and Databases

How To Install pgAdmin4 on Windows 10

pgAdmin is an Open Source administration and management tool for the PostgreSQL database. It includes a graphical administration interface, an SQL query tool, a procedural code debugger and much more. The tool is designed to answer the needs of developers, DBAs and system administrators alike.


This guide will walk you through the steps to install pgAdmin4 on a Windows 10. These instruction can also be applied if you are running a Windows 8, Windows Server 2016 or Windows Server 2019 in your environment.


Prerequisites

You will need one (physical or virtual) machine installed with Windows 10.

Download pgAdmin4

We will download pgAdmin4 4.28 the most latest release from the official download page.


Install pgAdmin4

Once the download complete, double click the downloaded file to begin the installation.


Click Next


Accept the license agreement, Click Next

Click Next

Click Next

Click Install

The installation process will take a moment to complete

Click Finish

This will also take a moment to start pgAdmin services

You will see a pgAdmin4 web interface loading like below.


For instance, if (Loading pgAdmin) stuck, then you have to make a change in your Windows registry.

Press Windows + R key to open Run command and enter regedit to open up registry editor.

Expand HKEY_CLASS_ROOT


Locate .js folder, double click Content Type to change its value.

Replace text/plain with text/javascript and click OK


Close the registry editor window.

Now, Shutdown pgAdmin server

Open pgAdmin4 from the Start Menu to run its service again.

For instance, if your pgAdmin web interface looks like as shown in image below, then you have to make a one more change in registry to allow css style to be loaded properly.


Press Windows + R and enter regedit in Run command to open up registry editor, expand HKEY_CLASSES_ROOT\.css and change Content Type from text/plain to text/css.

Shutdown and reload your pgAdmin server again. This time pgAdmin web interface will load quickly and ask you to a set master password.

Enter password of your choice and click OK.


Wrapping up

Now that you have successfully installed pgAdmin4 on your Windows machine, you can add your PostgreSQL servers to pgAdmin in order to administer and manage your databases.

Share:

0 comments:

Post a Comment

Comments with links will not be published.

Video Tutorials