Facebook Twitter Instagram
    TecAdmin
    • Home
    • Ubuntu 20.04
      • Upgrade Ubuntu
      • Install Java
      • Install Node.js
      • Install Docker
      • Install LAMP Stack
    • Tutorials
      • AWS
      • Shell Scripting
      • Docker
      • Git
      • MongoDB
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    Home»Databases»PostgreSQL»How To Install pgAdmin4 on Debian 10/9

    How To Install pgAdmin4 on Debian 10/9

    RahulBy RahulNovember 12, 20183 Mins ReadUpdated:May 27, 2021

    pgAdmin is a web-based interface for managing PostgreSQL database instances. With the help of pgAdmin4, We can create, access databases, run queries over databases easily. pgAdmin4 is available in both web and desktop versions. We can install it on a nix based systems, macOS, and Windows from official packages. The latest pgAdmin4 is helpful for managing PostgreSQL 9.2 and above versions.

    This tutorial will guide you through installation of pgAdmin4 on Debian Linux system.

    Prerequisites

    You must have PostgreSQL server installed on your system via an official apt repository. If you don’t have installed PostgreSQL, use below link to install.

    Install PostgreSQL on Debian 9

    Install pgAdmin4 on Debian

    pgAdmin4 packages are available under PostgreSQL official apt repository. We assume you already have configured apt repository during the installation of the database server.

    Execute below command on the terminal to begin pgAdmin4 installation on Debian.

    sudo apt-get install pgadmin4 pgadmin4-apache2
    

    The package pgadmin4-apache2 will integrate pgAdmin4 with Apache2 web server.

    install pgadmin4 Debian

    During the installation, you are required to setup pgAdmin4 admin login.

    Enter an email address to use as admin login id for your pgAdmin4 web interface. You can use any address of your choice.

    Then click OK.

    pgAdmin4 on Debian 9

    Now this will prompt to input password for the administrator account.

    pgAdmin4 on Debian 9 Stretch

    This will complete the installation of pgAdmin4 on your system. This will also make required changes on your local PostgreSQL system for connection.

    Now, pgAdmin4 is ready to use. Let’s connect pgAdmin4 with PostgreSQL database.

    Configure pgAdmin4 with PostgreSQL

    You have successfully installed pgAdmin4 on your Debian system. Now you can access pgAdmin4 in your favorite web browser.

    Use servers IP address or domain name followed by /pgAdmin4 as subdirectory URL.

    http://example.com/pgAdmin4
    

    After successful login, you will be redirected to pgAdmin4 dashboard. As this is a new installation, there will be no servers connected.

    Now, connect your first PostgreSQL instance by clicking on “Add New Server“.

    This will open a popup window. This tutorial is using the basic settings to connect the database instance. Enter the user-friendly name for the new instance connection under the General tab.

    Then switch to Connection tab. Enter hostname or IP address of your PostgreSQL instance. In my case, it’s running on localhost system, so I just the put localhost as the hostname. Then enter the username and password for PostgreSQL authentication.

    After that click Save button.

    After successful adding new instance, you will see an instance in the left sidebar. Here you can manage the database instance.

    Conclusion

    You have installed pgAdmin4, a web-based interface for the PostgreSQL server management. Now connect as many as PostgreSQL instances with the pgAdmin4.

    pgadmin4 PostgreSQL psql
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp
    Previous ArticleHow to Install and Configure pgAdmin4 on Ubuntu 18.04 & 16.04
    Next Article How to Install PostgreSQL 11 on Debian 9 (Stretch)

    Related Posts

    How To Configure PostgreSQL to Allow Remote Connections

    3 Mins Read

    How to Check the PostgreSQL Version

    Updated:August 6, 20212 Mins Read

    How to Install pgAdmin4 on Ubuntu 20.04

    Updated:April 9, 20214 Mins Read

    How to Install PostgreSQL and pgAdmin4 in Ubuntu 20.04

    Updated:July 1, 20215 Mins Read

    How To Install PostgreSQL Server on CentOS 8

    Updated:April 20, 20224 Mins Read

    How to Install PostgreSQL 11 on Debian 10 (Buster)

    Updated:July 25, 20192 Mins Read

    7 Comments

    1. joel on June 25, 2019 4:21 pm

      Hola…muy bueno el tuto, mi duda es cuando quiero realizar un backup a una base de datos me arroja un error de dump??, como puedo solucionar este error.

      Reply
    2. MothMan420cr on April 19, 2019 6:19 pm

      you need to reset postgres database user password.

      Run sudo -u postgres psql postgres.
      \password postgres.
      Enter a password.
      Close psql. \q.

      Login Again

      Reply
    3. maerd on March 7, 2019 11:16 am

      I can’t connect to server because I don’t know password for user postgres
      What is default password for user postgres or how to set password for user postgres?

      Reply
    4. in11002 on January 22, 2019 2:42 pm

      it works
      try /pgadmin4
      (in lowercase)

      Reply
    5. Prateek on December 13, 2018 6:49 pm

      Doesn’t work on Debian 9. I get a 404, when accessing /pgAdmin4

      Reply
      • Tim on January 18, 2019 4:50 pm

        Same

        Reply
      • enkidu on January 22, 2019 8:45 am

        Hi guys,

        same issue

        please try /pgadmin4
        (in lowercase)

        it works!

        Reply

    Leave A Reply Cancel Reply

    Recent Posts
    • How to Enable / disable Firewall in Windows
    • How to Install JAVA on Ubuntu 22.04
    • Switching Display Manager in Ubuntu – GDM, LightDM & SDDM
    • Changing the Login Screen Background in Ubuntu 22.04 & 20.04
    • How To Install PHP (8.1, 7.4 or 5.6) on Ubuntu 22.04
    Facebook Twitter Instagram Pinterest
    © 2022 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.