1. Overview
  2. Admin Guides
  3. Installation
  4. How to Download and Install pgAdmin 4 on Windows Server

How to Download and Install pgAdmin 4 on Windows Server

This guide will help you download and install pgAdmin 4 on a Windows Server. pgAdmin 4 is a comprehensive open-source tool used for managing PostgreSQL databases. It allows you to perform essential administrative tasks such as backing up, restoring, and modifying tables, under the guidance of our support team.

Note: pgAdmin 4 is not installed by default due to its size and because it is not a mandatory component. If you are comfortable using the PostgreSQL command line, installation of pgAdmin 4 is optional.

Prerequisites

  • Administrative access to the Windows Server.
  • Internet access to download software.

Step-by-Step Installation Guide

Step 1: Download pgAdmin 4

  1. Open your web browser and navigate to the official pgAdmin website.
  2. Click on the "Download" button for the Windows version.
  3. Save the installer file to a convenient location on your server.

Step 2: Install pgAdmin 4

  1. Locate the downloaded installer file (commonly named pgadmin4-x-x-x.exe, where x-x-x represents the version number).
  2. Double-click the installer file to start the installation process.
  3. Follow the on-screen instructions:
    • Accept the license agreement.
    • Choose the installation directory (default is usually fine).
    • Select components (default selection is recommended).
    • Configure additional tasks like creating a desktop shortcut if desired.
  4. Click "Install" to begin the installation.
  5. Once the installation is complete, click "Finish" to exit the setup.

Step 3: Launch pgAdmin 4

  1. Go to the Start menu and find pgAdmin 4 in your list of installed applications.
  2. Open pgAdmin 4 to launch the application.

Step 4: Connect to Your DashboardFox PostgreSQL Database

  1. In pgAdmin 4, click on "Add New Server" or use the server registration wizard.

  2. Enter the connection details provided by your support team:

    • Name: A descriptive name for your server connection.
    • Host: The IP address or hostname of your PostgreSQL server.
    • Port: 5432.
    • Maintenance Database: yurbi.
    • Username: postgres.
    • Password: yurbi. (for linux the password is stored in the .passwords file in the root directory)

  3. Click "Save" to establish the connection.

Conclusion

You have successfully installed pgAdmin 4 on your Windows Server and connected it to your Yurbi PostgreSQL database. You can now use it to perform any necessary administrative updates under the direction of our support team.

If you encounter any issues or need further assistance, please contact our support team for help.