2 Ways to install pgAdmin 4 on Windows 11 or 10 - H2S Media .

PowerShell Coding

9 Views

        

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

Winget search 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.

Select the install mode

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“.

Installation is Completed

The pgAdmin setup is ready

pgAdmin 4 SetupAccept License

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.

Use Winget to install pgAdmin Windows 11 or 10

pgAdmin in the Windows Start menu

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.

Set a Master Password for pgAdmin

Set a Master Password for pgAdmin

6. Connect pgAdmin to Remote PostgreSQL Server

To establish a connection with your remote PostgreSQL Database, click on the Add New Server.

Add New Server in PostgreSQL managment tool

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.

Resgiter you server by adding a name

Assign a name to New Server

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.

Add remote PostgreSQL server details windows 10

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.

Install pgAdmin 4 on Windows 11 or 10

Other Articles:

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…