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.