# 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