# 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 backports repository
echo "deb https://deb.debian.org/debian/ $(sed -n 's/^VERSION_CODENAME=//p' /etc/os-release)-backports main" | tee -a /etc/apt/sources.list.d/backports.list

# 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