Home / ubuntu / Questions / 1230350
Accepted
cjones
Asked: 2020-04-25 06:48:10 +0800 CST

Can't install pgAdmin 4 on 20.04 LTS

  • 772

Basically, follow the steps as outlined here: https://wiki.postgresql.org/wiki/Apt.

  1. sudo apt-get install curl ca-certificates gnupg
  2. curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
  3. sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
  4. sudo apt-get update
  5. sudo apt-get install pgadmin4

(The actual command for the last step includes postgresql-11. I never do that because I just want pgadmin4 and have never had issues with it working properly.)

Anyway, this is what happens when trying to install:

Reading package lists... Done
Building dependency tree       
Reading state information... Done
Package pgadmin4 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'pgadmin4' has no installation candidate

I've redone the steps with the same result.

I did also try to do the following, but it requires python3.7 which I'm not going to install.

sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt eoan-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

Verified focal shows up at apt.postgresql.org:

enter image description here

Kind of stumped after that as to what to do.

Suggestions?

apt postgresql pgadmin

3 Answers

  1. Best Answer

    I was able to install pgadmin4 on ubuntu 20.04 (focal fossa) using the following article as a base: https://linuxhint.com/install-pgadmin4-ubuntu/

    A few changes to the instructions are required:

    1. In part 2:

      sudo apt-get install build-essential libssl-dev libffi-dev libgmp3-dev
sudo apt-get install python3-virtualenv libpq-dev python3-dev

    2. In part 5:
      The latest version for the moment is:

      https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.20/pip/pgadmin4-4.20-py2.py3-none-any.whl

      (I used release, not a daily snapshot)

    3. In part 6: Use

      pip install pgadmin4-4.20-py2.py3-none-any.whl

    4. In part 7:
      Use 'python3.8' instead of 'python2.7'

    That's all.
    Worked for me.

    • 10

  2. Update: Please note that it's possible install pgadmin4 (4.21) directly from the repositories now.

    The problem of the upstream debian repository was the python 3.8 support. They said that was fixed in this commit, but they are apparently missing this: https://github.com/postgres/pgadmin4/commit/b7dad25d3eb29fae05fef4f161dea644f080276f

    Also the upstream has no support for Ubuntu 20.04 yet. See the status at this date (2020-05-13): https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/

    If someone were to distribute pgadmin4 directly in Ubuntu it would be really helpfully, but it is not available yet.

    • 5

  3. As a workaround you could run pgadmin4 in docker

    docker run -p 5050:80 \
-e 'PGADMIN_DEFAULT_EMAIL=THE_EMAIL_YOU_WANT_TO_USE' \
-e 'PGADMIN_DEFAULT_PASSWORD=XXXXX' \
-d dpage/pgadmin4

    Then point your browser to http://localhost:5050

    • 3