How to install pgAdmin 4 on Linux Mint

Question

I'm running Linux Mint 19 Tara, and trying to follow the instructions here with the goal of installing pgAdmin4 as a desktop app. There seems to be a problem involving the authentication of the repository.

The apt-key step seems to work, as I observe PostgreSQL Debian Repository in the apt-key list.

I don't have a deb command (I imagine this is a Mint vs Ubuntu difference?), so I used
add-apt-repository http://apt.postgresql.org/pub/repos/apt/ tara-pgdg main
instead, after which I observe
deb http://apt.postgresql.org/pub/repos/apt/ bionic main
in /etc/apt/sources.list.d/additional-repositories.list.

At this point running either apt-get upgrade or apt-get update shows an error
The repository 'http://apt.postgresql.org/pub/repos/apt bionic Release' does not have a Release file.

How can I proceed? It seems unlikely that there really isn't a release file; I can see what looks like an authentication list at https://apt.postgresql.org/pub/repos/apt/dists/bionic-pgdg/. Do I have a path wrong or something?

Answer 1

1. Open terminal and type:

    wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
   

2. Open Software Sources and click on "Additional repositories" and paste the following for Linux Mint 19 (it's based on Ubuntu Bionic):

    deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
   

   or the following for Linux Mint 20 (based on Ubuntu Focal Fossa):

    deb http://apt.postgresql.org/pub/repos/apt/ focal-pgdg main
   

it should look like this:

Press "OK" and that will automatically update cache.

3. Now open terminal and type the following:

    sudo apt update
    sudo apt install pgadmin4
   

That should install pgadmin4.

Answer 2

The following worked for me in Linux Mint 19.1 modified from docs because my machine had $(lsb_release -cs) returning tessa which was not working but bionic was working.

Setup the repository

Install the public key for the repository (if not done previously):

curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add

Create the repository configuration file:

sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/bionic pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

Install pgAdmin

Install for both desktop and web modes:

sudo apt install pgadmin4

Answer 3

Python approach always work

$ sudo mkdir /var/lib/pgadmin
$ sudo mkdir /var/log/pgadmin
$ sudo chown $USER /var/lib/pgadmin
$ sudo chown $USER /var/log/pgadmin
$ python3 -m venv pgadmin4
$ source pgadmin4/bin/activate
(pgadmin4) $ pip install pgadmin4

(pgadmin4) $ pgadmin4

or

curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add

sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/focal/ pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

sudo apt install pgadmin4