PostgreSQL

Install the PostgreSQL client connection tool pgAdmin 4 for Windows

Page update date :
Page creation date :

Operating environment

PostgreSQL (Server)
  • PostgreSQL 15
Windows (Server)
  • Windows Server 2019
pdAdmin (Client)
  • pdAdmin 4 v7.0
Windows (Client)
  • Windows 11

Prerequisites

Windows
  • Windows 10 or later
  • Windows Server 2016 or later

premise

  • PostgreSQL is already set up on another server and can be connected to from the outside. The pgAdmin-only installation does not require a PostgreSQL server, but it is required as a destination confirmation.

About pgAdmin

pgAdmin is a GUI tool for working with databases officially supported by PostgreSQL. Since the status of the database is displayed as a screen, I think that information and operations are easier to understand than the command base. However, not all database operations are supported, and some may require the use of commands. Most of the basic operations can be operated with the GUI.

By the way, pgAdmin is a client tool for manipulating databases. You do not need to install a PostgreSQL server in an environment that uses pgAdmin. If you have a PostgreSQL database on another server, you will operate that database over the network with pgAdmin.

pgAdmin can be installed with PostgreSQL. You do not need to install pgAdmin separately on the PostgreSQL server.

download

In a web browser, access the following pages:

There is a link for each version, so download the latest version.

install

Launch the downloaded installer.

Select Install for me only. It doesn't matter which one you choose, but in this case, I'm choosing the recommended one.

Click the Next button.

Read the License Agreement carefully, check "I accept the agreement" and click the "Next" button.

If there is no change in the installation destination, click the "Next" button.

If there is no change in the folder name in the start menu, click the "Next" button.

If there are no problems with the settings, click the "Install" button to start the installation.

When the installation is complete, click the "Finish" button to close it.

Starting pgAdmin

Select "pdAdmin 4 v7" from the Start menu. The name may change depending on the version.

Setting a Master Password

When you start pdAdmin for the first time, you will be asked to register a master password. It is necessary to configure the settings so that a third party cannot manipulate the database without permission.

Connection check

Check if you can connect to the PostgreSQL database on the other server. The connection destination information varies depending on the environment, so only the procedure is described here.

Once pgAdmin is started, right-click on Servers and select "Register > Server...".

On the General tab, the Name should be a name that will help you identify the server.

Select the Connection tab. Enter "Host name/address", "Maintenance databalse", "Username", and "Password". If you don't want to enter the password every time, turn on "Save password". By the way, pdAdmin may not be able to resolve the name of Host, so in that case, specify the IP address directly.

Fill in the other input fields as needed. When you're done, click the "Save" button.

If you can connect to the database of the target server, the verification is complete.

Settings to allow other PCs to connect to the PostgreSQL database (Windows version)