update.sh

#!/usr/bin/env bash
set -Eeuo pipefail

# TODO scrape this somehow?
newVersions=(
	15
    14
)
oldVersions=(
	15
	14
	13
	12
	11
	10
	9.6
	#9.5
	#9.4
	#9.3
	#9.2
)
suite='bullseye'

# Alias if it's linux
unameOut="$(uname -s)"
case "${unameOut}" in
    Linux*)     machine=Linux;;
    Darwin*)    machine=Mac;;
    CYGWIN*)    machine=Cygwin;;
    MINGW*)     machine=MinGw;;
    *)          machine="UNKNOWN:${unameOut}"
esac

if [[ $machine == "Mac" ]]; then
    echo "Using gsed"
    alias sed='gsed'
fi

for i in "${!newVersions[@]}"; do
	new="${newVersions[$i]}"
	echo "# $new"
	docker pull "postgres:$new-$suite" > /dev/null
	(( j = i + 1 ))
	for old in "${oldVersions[@]:$j}"; do
		dir="$old-to-$new"
		echo "- $old -> $new ($dir)"
		oldVersion="$(
			docker run --rm -e OLD="$old" "postgres:$new-$suite" bash -Eeuo pipefail -c '
				sed -i "s/\$/ $OLD/" /etc/apt/sources.list.d/pgdg.list
				apt-get update -qq 2>/dev/null
				apt-cache policy "postgresql-$OLD" \
					| awk "\$1 == \"Candidate:\" { print \$2; exit }"
			'
		)"
		echo "  - $oldVersion"
		if [ "$oldVersion" = '(none)' ]; then
			continue
		fi
		mkdir -p "$dir"
		sed \
			-e "s!%%POSTGRES_OLD%%!$old!g" \
			-e "s!%%POSTGRES_OLD_VERSION%%!$oldVersion!g" \
			-e "s!%%POSTGRES_NEW%%!$new!g" \
			-e "s!%%SUITE%%!$suite!g" \
			Dockerfile.template \
			> "$dir/Dockerfile"
		cp docker-upgrade "$dir/"
		if [[ "$old" != 9.* ]]; then
			gsed -i '/postgresql-contrib-/d' "$dir/Dockerfile"
		fi

        cd $dir
        docker buildx build . --push --platform linux/arm64/v8,linux/amd64 --tag nline/timescale-upgrade:$dir
        cd ..
	done
done