Learn the steps to install the popular pgAdmin on Windows 11 or 10 to manage local or remote PostgreSQL Database directly on your system.
Just like popular phpMyAdmin to graphically manage MySQL or MariaDB databases, here we have pgAdmin. It is also a free and open source software to provide a graphical interface to develop and administrators of PostgreSQL databases. The open source license of pgAdmin is inherited from the PostgreSQL project. pgAdmin runs on Windows, Linux, macOS, and other Unix derivatives.
However, unlike Linux, pgAdmin on Windows and macOS can easily be installed to manage remote or local running PostgreSQL.
Well, pgAdmin offers two types of installation one is Desktop Deployment and other Server Deployment.
Server Deployment: In this method of installation, the pgAdmin is installed as a web application with the help of a web server on a command line server, so that single or multiple users can access it simultaneously using a web browser. Of course, credentials are required for security.
Desktop Deployment: This type of installation is like any other software installed locally on the computer. This means you don’t require any browser to connect and access PostgreSQL but are limited to only one user who is currently logged on to the operating system. Also, for this, the user needs a GUI running a supported OS.
Well, installing pgAdmin as a central web application in the local network (server deployment) is useful if you don’t want to restrict it to only one PC. However, as we are using Windows here, hence most of the users of this OS would like to have a Desktop Deployment only and in this tutorial, we will discuss how to install the pgAdmin App and connect it with a remote PostgreSQL Database server.
Steps to install pgAdmin on Windows 11 or 10
The steps given will be the same for both Windows 10 and the latest one 11 as well. Even the old OS versions that are not supported by Microsoft such as Windows 7 users can follow this tutorial.
#1st Way is using the Winget command line
1. Open Windows Terminal or Powershell
As our first method involves the command line to install pgAdmin on Windows 11 or 10, hence, we have to open Windows Powershell, first. Right-click on your Windows Start button and select PowerShell (Admin) in Windows 10 whereas Windows Terminal (Admin) in Windows 11.
2. Install pgAdmin 4 using Winget
Well, like Linux, Microsoft since Windows 10 also offers a package manager by default on its operating systems called “Winget“. Although, the list of packages to install using it is not as wide as Linux package managers, yet enough to get some popular software easily. The good thing is the latest version of pgAdmin is available through it. Hence, let’s run a single command to get pgAdmin 4.
To check the pgAdmin version available via Winget
wignet search pgAdmin
To install:
winget install pgAdmin
After this jump to Step 5 of this article.
#2nd method using the official pgAdmin executable setup…
2. Download pgAdmin
The official website of …….
Source: https://www.how2shout.com/how-to/2-ways-to-install-pgadmin-4-on-windows-11-or-10.html