mirror of
https://github.com/getsentry/self-hosted.git
synced 2025-12-08 19:46:14 +00:00
45 lines
2.1 KiB
Bash
45 lines
2.1 KiB
Bash
echo "${_group}Ensuring proper PostgreSQL version ..."
|
|
|
|
if [[ -n "$($CONTAINER_ENGINE volume ls -q --filter name=sentry-postgres)" && "$($CONTAINER_ENGINE run --rm -v sentry-postgres:/db busybox cat /db/PG_VERSION 2>/dev/null)" == "9.6" ]]; then
|
|
$CONTAINER_ENGINE volume rm sentry-postgres-new || true
|
|
# If this is Postgres 9.6 data, start upgrading it to 14.0 in a new volume
|
|
$CONTAINER_ENGINE run --rm \
|
|
-v sentry-postgres:/var/lib/postgresql/9.6/data \
|
|
-v sentry-postgres-new:/var/lib/postgresql/14/data \
|
|
tianon/postgres-upgrade:9.6-to-14
|
|
|
|
# Get rid of the old volume as we'll rename the new one to that
|
|
$CONTAINER_ENGINE volume rm sentry-postgres
|
|
$CONTAINER_ENGINE volume create --name sentry-postgres
|
|
# There's no rename volume in Docker so copy the contents from old to new name
|
|
# Also append the `host all all all trust` line as `tianon/postgres-upgrade:9.6-to-14`
|
|
# doesn't do that automatically.
|
|
$CONTAINER_ENGINE run --rm -v sentry-postgres-new:/from -v sentry-postgres:/to alpine ash -c \
|
|
"cd /from ; cp -av . /to ; echo 'host all all all trust' >> /to/pg_hba.conf"
|
|
# Finally, remove the new old volume as we are all in sentry-postgres now.
|
|
$CONTAINER_ENGINE volume rm sentry-postgres-new
|
|
echo "Re-indexing due to glibc change, this may take a while..."
|
|
echo "Starting up new PostgreSQL version"
|
|
start_service_and_wait_ready postgres
|
|
|
|
# Wait for postgres
|
|
RETRIES=5
|
|
until $dc exec postgres psql -U postgres -c "select 1" >/dev/null 2>&1 || [ $RETRIES -eq 0 ]; do
|
|
echo "Waiting for postgres server, $((RETRIES--)) remaining attempts..."
|
|
sleep 1
|
|
done
|
|
|
|
# VOLUME_NAME is the same as container name
|
|
# Reindex all databases and their system catalogs which are not templates
|
|
DBS=$($dc exec postgres psql -qAt -U postgres -c "SELECT datname FROM pg_database WHERE datistemplate = false;")
|
|
for db in ${DBS}; do
|
|
echo "Re-indexing database: ${db}"
|
|
$dc exec postgres psql -qAt -U postgres -d ${db} -c "reindex system ${db}"
|
|
$dc exec postgres psql -qAt -U postgres -d ${db} -c "reindex database ${db};"
|
|
done
|
|
|
|
$dc stop postgres
|
|
fi
|
|
|
|
echo "${_endgroup}"
|