Debian Packages

Prebuilt Debian 12 “Bookworm” and Debian 13 “Trixie” packages are available from https://apt.postgresql.org/. You can add this as a repository to your Debian Bookworm i.e. Debian Trixie installation and just do the normal routine installing software.

Installation on Debian 12 “Bookworm” and Debian 13 “Trixie”

Installation

# Become superuser
su

# Install tools
apt-get install curl ca-certificates apt-transport-https gnupg2 wget

# Use official PostgreSQL repo, apt.postgresql.org
apt-get install postgresql-common
/usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

# Use offical grafana repo, apt.grafana.com
mkdir -p /etc/apt/keyrings/
wget -q -O - https://apt.grafana.com/gpg.key | gpg --dearmor | tee /etc/apt/keyrings/grafana.gpg > /dev/null
echo "deb [signed-by=/etc/apt/keyrings/grafana.gpg] https://apt.grafana.com stable main" | tee -a /etc/apt/sources.list.d/grafana.list

# Install elephant-shed
apt-get update
apt-get install elephant-shed sscg

# Choose desired PostgreSQL versions to install
# apt-get install postgresql-<desired_version> for instance version 17
apt-get install postgresql-17

# Every user in the group "elephant-shed" is allowed to login at the portal
# Add all needed users to this group
/sbin/adduser <USERNAME> elephant-shed

# Every user in the group "sudo" is allowed execute sudo commands, needed for cockpit
# Add all needed users to this group
/sbin/adduser <USERNAME> sudo

Notice: The packages contain the Elephant Shed components and some basic configuration. Tuning, user management, and setting up a firewall remain to be done on the user’s side.