apt install -y sudo

# Import the repository signing key:
sudo apt install -y curl ca-certificates
sudo install -d /usr/share/postgresql-common/pgdg
sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc

# Create the repository configuration file:
sudo sh -c 'echo "deb [signed-by=/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

# Update the package lists:
apt-get update

# Install PostgreSQL
apt-get install -y postgresql-18 postgresql-client-18 postgresql-contrib-18

# Allow trust connection from localhost
sed -i 's/scram-sha-256/trust/g' /etc/postgresql/18/main/pg_hba.conf
su - postgres -c "/usr/lib/postgresql/18/bin/pg_ctl reload -D /var/lib/postgresql/18/main"