• Home
  • Ubuntu 18.04
    • Whats New?
    • Upgrade Ubuntu
    • Install Java
    • Install Node.js
    • Install Docker
    • Install Git
    • Install LAMP Stack
  • Tutorials
    • AWS
    • Shell Scripting
    • Docker
    • Git
    • MongoDB
  • Funny Tools
  • FeedBack
  • Submit Article
  • About Us
TecAdmin
Menu
  • Home
  • Ubuntu 18.04
    • Whats New?
    • Upgrade Ubuntu
    • Install Java
    • Install Node.js
    • Install Docker
    • Install Git
    • Install LAMP Stack
  • Tutorials
    • AWS
    • Shell Scripting
    • Docker
    • Git
    • MongoDB
  • Funny Tools
  • FeedBack
  • Submit Article
  • About Us

How to Install pgAdmin4 on Debian Linux

Written by Rahul, Updated on July 25, 2019
PostgreSQL pgadmin4, PostgreSQL, psql

Introduction

pgAdmin is a web-based interface for management of PostgreSQL database instances. It can be installed on Linux, Unix, Mac OS X, and Windows to manage PostgreSQL 9.2 and above versions

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.

Share it!
Share on Facebook
Share on Twitter
Share on Reddit
Share on Tumblr
Rahul
Rahul
Connect on Facebook Connect on Twitter

I, Rahul Kumar am the founder and chief editor of TecAdmin.net. I am a Red Hat Certified Engineer (RHCE) and working as an IT professional since 2009..

Related Posts

  • How to Install PostgreSQL on CentOS 8 & RHEL 8

    November 10, 2019
  • How to Install PostgreSQL 11 on Debian 10 (Buster)

    July 21, 2019
  • How to Install PostgreSQL 11 on Debian 9 (Stretch)

    November 12, 2018
  • How to Install and Configure pgAdmin4 on Ubuntu 18.04 & 16.04

    November 11, 2018
  • How To Install PostgreSQL 11 on Fedora 30/29/28

    October 30, 2018

7 Comments

  1. Avatar joel Reply to joel
    June 25, 2019 at 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.

  2. Avatar MothMan420cr Reply to MothMan420cr
    April 19, 2019 at 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

  3. Avatar maerd Reply to maerd
    March 7, 2019 at 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?

  4. Avatar in11002 Reply to in11002
    January 22, 2019 at 2:42 pm

    it works
    try /pgadmin4
    (in lowercase)

  5. Avatar Prateek Reply to Prateek
    December 13, 2018 at 6:49 pm

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

    • Avatar Tim Reply to Tim
      January 18, 2019 at 4:50 pm

      Same

    • Avatar enkidu Reply to enkidu
      January 22, 2019 at 8:45 am

      Hi guys,

      same issue

      please try /pgadmin4
      (in lowercase)

      it works!

Leave a Reply

Cancel reply

Popular Posts

  • How to Install Python 3.8 on Ubuntu, Debian and LinuxMint
  • How to Restart Network Service on CentOS 8 or RHEL 8
  • How to Check IP Address on CentOS 8
  • How to Install Java 11/8 on Amazon Linux
  • How to Configure Static IP on CentOS 8 (CLI)
Copyright © 2013-2019 TecAdmin.net. All Rights Reserved. This site uses cookies. By using this website you agree with our term and services
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkNo
Revoke cookies