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.
No comments: