Ubuntu-Pakete

Fertige Pakete für Ubuntu 22.04 “Jammy” und Ubuntu 24.04 “Noble” sind in dem officielle PostgreSQL Repository zu finden.

Installation für Ubuntu 22.04 “Jammy” und Ubuntu 24.04 “Noble”

Für jammy und noble sind Elephant Shed in apt.postgresql.org enthalten.

Installation

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

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

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

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

# Choose desired PostgreSQL versions to install
# sudo apt-get install postgresql-<desired_version> for instance version 17
sudo 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
sudo 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

Hinweis: Die Pakete enthalten nur die Komponenten und eine Grundkonfiguration. Um Tuning, Nutzerverwaltung und auch um eine Firewall muss sich hier selbst gekümmert werden.