pgAdmin 4: APT repository

Supported platform matrix:

+----------+--------------+-------------------------+
| Platform | Architecture | First supported release |
+----------+--------------+-------------------------+
| bookworm |  all amd64   |           7.0           |
|  jammy   |  all amd64   |           6.9           |
|  noble   |  all amd64   |           8.7           |
| resolute |  all amd64   |           9.15          |
|  trixie  |  all amd64   |           9.8           |
+----------+--------------+-------------------------+

Platforms that are no longer supported. Packages for these remain available
from https://pgadmin-archive.postgresql.org/, from where they can be manually
downloaded; the archive site cannot be used as a repository.

+----------+--------------+-------------------------+------------------------+
| Platform | Architecture | First supported release | Last supported release |
+----------+--------------+-------------------------+------------------------+
|  bionic  |  all amd64   |           4.22          |          6.21          |
| bullseye |  all amd64   |           4.30          |          9.14          |
|  buster  |  all amd64   |           4.22          |          8.9           |
|  disco   |  all amd64   |           4.22          |          4.22          |
|   eoan   |  all amd64   |           4.22          |          4.29          |
|  focal   |  all amd64   |           4.22          |          9.2           |
|  groovy  |  all amd64   |           4.30          |          5.5           |
| hirsute  |  all amd64   |           5.3           |          6.4           |
|  impish  |  all amd64   |           6.2           |          6.11          |
| kinetic  |  all amd64   |           6.16          |          7.5           |
|  lunar   |  all amd64   |           7.1           |          8.3           |
|  mantic  |  all amd64   |           8.0           |          8.9           |
| oracular |  all amd64   |           8.13          |          9.5           |
|  plucky  |  all amd64   |           9.3           |          9.14          |
| questing |  all amd64   |           9.11          |          9.17          |
| stretch  |  all amd64   |           4.22          |          5.3           |
|  xenial  |  all amd64   |           4.22          |          4.30          |
+----------+--------------+-------------------------+------------------------+

To use this repository, run the following commands:

#
# Setup the repository
#

# Install the public key for the repository (if not done previously):
curl -fsS https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo gpg --dearmor -o /usr/share/keyrings/packages-pgadmin-org.gpg

# Create the repository configuration file:
sudo sh -c 'echo "deb [signed-by=/usr/share/keyrings/packages-pgadmin-org.gpg] https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

#
# Install pgAdmin
#

# Install for both desktop and web modes:
sudo apt install pgadmin4

# Install for desktop mode only:
sudo apt install pgadmin4-desktop

# Install for web mode only: 
sudo apt install pgadmin4-web 

# Configure the webserver, if you installed pgadmin4-web:
sudo /usr/pgadmin4/bin/setup-web.sh