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
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 pgAdmin offers an executable file to easily install this PostgreSQL’s GUI interface app. Hence, just visit it using the given link and download the same on your Windows 11 or 10 system. You will have the list of the supported versions, select the latest one, and download the same.
3. Run the Setup
Once you have the setup on your system, double-click on it to run the same. Click on Install for me only (recommended), however, if you want to install pgAdmin for all users’ accounts on your system then can for the second option.
4. Install pgAdmin on Windows 11 or 10
Now, start the installation by clicking the Next button, and then Accept the license. After that again click the Next buttons to accept the default setting until the setup starts the installation process. Soon, the installation will be completed, confirm it by pressing “Finish“.
5. Launch the pgAdmin
To start the application or GUI interface app for PostgreSQL Database, go to your Windows search and there type pgAdmin, as its icon appears, click to run the same.
After the first start, you will first be asked to assign a master password. Remember this is used to store the sensitive connection data to your databases in encrypted form. The master password itself is not stored anywhere, so you have to remember it well.
6. Connect pgAdmin to Remote PostgreSQL Server
To establish a connection with your remote PostgreSQL Database, click on the Add New Server.
In this dialog box, you enter a name for your server to easily identify it later. It can be the actual name of the remote server or whatever you want to call it on pgAdmin.
After that you have two options: Configure a direct connection to the server via TCP or Configure an indirect connection to the server via SSH tunnel. You can choose the one you want. Here we are going for a TCP connection and for that click on the Connection Tab.
Now, in the Connection tab, enter the Ip-address or domain name of the server on which your PostgreSQL instance is installed.
Leave the Port and Maninatance Database values as they are and just add the PostgreSQL instance Database Username and Password that you want to access on pgAdmin.
Next, click on the Save button to let the program establish a connection.
Finally, you will have the graphical user interface with PostgreSQL Database to create, delete and edit tables, including other tasks such as backup and restore.
⇒ MySQL GUI Tools for Windows and Ubuntu/Linux: Top 8 free
⇒ Install Top 10 essential software on Windows 11 using the command
⇒ How to install XAMPP on Windows 10 using the Command prompt
⇒ How to Install Sensu Go Monitoring on Windows
⇒ How to install Ubuntu 22.04 on Windows 11 WSL…