mirror of
https://github.com/hanzoai/insights.git
synced 2026-10-30 16:15:31 +00:00
zeekay
10e6fec4c0
The rule table mapped HOG_ -> FN_ ahead of any POSTHOG rule, so POSTHOG_FOO split into POST + HOG_ and came out POSTFN_FOO. Nothing sets that. The live pods set INSIGHTS_SKIP_MIGRATION_CHECKS, which bin/migrate-check reads on the container entrypoint, so the misspelling does not degrade a feature -- it runs migrate --check against a database whose history this tree does not share and the container never starts. Both replacements are measured against the shipped tree rather than chosen: every HOG_ name with a counterpart there is spelled INSIGHTS_ (HOG_QL -> INSIGHTS_QL, HOG_FUNCTION_TEMPLATES -> INSIGHTS_FUNCTION_TEMPLATES, 12 of 12 determinate cases), and FN_ appears in it nowhere. Upstream carries 95 HOG_ tokens and zero FN_ ones, so repairing FN_ back out is exactly the inverse of the bad rule and cannot collide with an upstream name. The rule is fixed for the next convergence, and the tree it already produced is repaired in the same commit -- the codemod is idempotent against its own output, so it cannot undo this itself.
478 lines
21 KiB
Bash
Executable File
478 lines
21 KiB
Bash
Executable File
#!/usr/bin/env bash
|
||
|
||
set -e
|
||
|
||
echo "Upgrading Insights. This will cause a few minutes of downtime."
|
||
read -r -p "Do you want to upgrade Insights? [y/N] " response
|
||
if [[ "$response" =~ ^([yY][eE][sS]|[yY])+$ ]]
|
||
then
|
||
echo "OK!"
|
||
else
|
||
exit
|
||
fi
|
||
|
||
if [ "$REGISTRY_URL" == "" ]
|
||
then
|
||
export REGISTRY_URL="insights/insights"
|
||
fi
|
||
|
||
export INSIGHTS_APP_TAG="${INSIGHTS_APP_TAG:-latest}"
|
||
|
||
echo "Checking for named postgres and datastore volumes to avoid data loss when upgrading from < 1.39"
|
||
if docker volume ls | grep -Pzoq 'datastore-data\n(.|\n)*postgres-data\n'
|
||
then
|
||
DOCKER_VOLUMES_MISSING=FALSE
|
||
echo "Found postgres and datastore volumes, proceeding..."
|
||
else
|
||
DOCKER_VOLUMES_MISSING=TRUE
|
||
echo ""
|
||
echo ""
|
||
echo "π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨"
|
||
echo "π¨π¨π¨ WARNING: POTENTIAL DATA LOSS π¨π¨π¨π¨π¨"
|
||
echo "π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨"
|
||
echo ""
|
||
echo ""
|
||
echo "We were unable to find named datastore and postgres volumes."
|
||
echo "If you created your Insights stack PRIOR TO August 12th, 2022 / v1.39.0, the Postgres and Datastore containers did NOT have persistent named volumes by default."
|
||
echo "If you choose to upgrade, you π£ will likely lose data π£ contained in these anonymous volumes."
|
||
echo ""
|
||
echo "See the discussion here for more information: https://github.com/Insights/insights/pull/11256"
|
||
echo ""
|
||
echo "WE STRONGLY RECOMMEND YOU:"
|
||
echo ""
|
||
echo "π Stop this script and do not proceed"
|
||
echo "β
Back up your entire environment/installation (vm, host, etc.), including all docker containers and volumes:"
|
||
echo "β
Specifically back up the contents of :"
|
||
echo " β /var/lib/postgresql/data in the postgres (*_db_1) container"
|
||
echo " β /var/lib/datastore in the datastore (*_datastore_1) container"
|
||
echo "and be ready to check/recopy the data before you boot Insights next."
|
||
read -r -p "Do you want to proceed anyway? [y/N] " response
|
||
if [[ "$response" =~ ^([yY][eE][sS]|[yY])+$ ]]
|
||
then
|
||
echo "OK!"
|
||
else
|
||
exit
|
||
fi
|
||
fi
|
||
|
||
# Upgrading pulls a full set of new images, which needs significant free disk.
|
||
# A nearly full disk fails the pull or leaves containers crashing mid-upgrade,
|
||
# so check up front and offer to prune old images before anything is changed.
|
||
# This runs after the data-loss volume check above so the user has acknowledged
|
||
# that warning before `docker system prune` removes any stopped containers.
|
||
DOCKER_ROOT_DIR=$(docker info --format '{{ .DockerRootDir }}' 2>/dev/null || echo /var/lib/docker)
|
||
disk_use_pct() {
|
||
df -P "$DOCKER_ROOT_DIR" 2>/dev/null | awk 'NR==2 { gsub(/%/,""); print $5 }'
|
||
}
|
||
DISK_USE=$(disk_use_pct)
|
||
if [ -n "$DISK_USE" ] && [ "$DISK_USE" -ge 80 ]; then
|
||
echo ""
|
||
echo "β οΈ The disk holding Docker data ($DOCKER_ROOT_DIR) is ${DISK_USE}% full."
|
||
echo "The upgrade pulls a full set of new images and may fail or leave the stack broken without enough free space."
|
||
read -r -p "Remove unused Docker images and build cache now? (docker system prune -a --force) [y/N] " response
|
||
if [[ "$response" =~ ^([yY][eE][sS]|[yY])+$ ]]; then
|
||
docker system prune -a --force
|
||
DISK_USE=$(disk_use_pct)
|
||
echo "Disk is now ${DISK_USE:-unknown}% full."
|
||
fi
|
||
if [ -n "$DISK_USE" ] && [ "$DISK_USE" -ge 90 ]; then
|
||
read -r -p "Disk is still ${DISK_USE}% full. Continue with the upgrade anyway? [y/N] " response
|
||
if [[ ! "$response" =~ ^([yY][eE][sS]|[yY])+$ ]]; then
|
||
echo "Upgrade cancelled. Free up disk space and try again."
|
||
exit 1
|
||
fi
|
||
fi
|
||
fi
|
||
|
||
# a previous version of the deploy script should have been quoting the caddy_host env var
|
||
tmp="$(mktemp)"
|
||
awk '
|
||
/^[[:space:]]*($|#)/ { print; next } # keep blanks/comments
|
||
{
|
||
# split on first "=" only
|
||
p = index($0, "="); if (!p) { print; next }
|
||
key = substr($0,1,p-1); val = substr($0,p+1)
|
||
|
||
# trim
|
||
sub(/^[[:space:]]+/,"",key); sub(/[[:space:]]+$/,"",key)
|
||
sub(/^[[:space:]]+/,"",val); sub(/[[:space:]]+$/,"",val)
|
||
|
||
# already quoted?
|
||
if (val ~ /^".*"$/ || val ~ /^'\''.*'\''$/) { print key "=" val; next }
|
||
|
||
# quote if value has space, comma, or ://
|
||
if (val ~ /[[:space:],]|:\/\//) {
|
||
gsub(/"/, "\\\"", val)
|
||
print key "=\"" val "\""
|
||
} else {
|
||
print key "=" val
|
||
}
|
||
}
|
||
' .env > "$tmp" && mv "$tmp" .env
|
||
|
||
if [[ -f ".env" ]]; then
|
||
set -a # auto-export all variables
|
||
. ./.env # or: source .env
|
||
set +a
|
||
else
|
||
echo "No .env file found. Please create it with INSIGHTS_SECRET and DOMAIN set."
|
||
exit 1
|
||
fi
|
||
|
||
# we introduced ENCRYPTION_SALT_KEYS and so if there isn't one, need to add it
|
||
# check for it in the .env file
|
||
if ! grep -q "ENCRYPTION_SALT_KEYS" .env; then
|
||
ENCRYPTION_KEY=$(openssl rand -hex 16)
|
||
echo "ENCRYPTION_SALT_KEYS=$ENCRYPTION_KEY" >> .env
|
||
echo "Added missing ENCRYPTION_SALT_KEYS to .env file"
|
||
source .env
|
||
else
|
||
# Read the existing key
|
||
EXISTING_KEY=$(grep "ENCRYPTION_SALT_KEYS" .env | cut -d '=' -f2)
|
||
|
||
# Check if the existing key is in the correct format (32 bytes base64url)
|
||
if [[ ! $EXISTING_KEY =~ ^[A-Za-z0-9_-]{32}$ ]]; then
|
||
echo "ENCRYPTION_SALT_KEYS is not in the correct fernet format and will not work"
|
||
echo "π Stop this script and do not proceed"
|
||
echo "remove ENCRYPTION_SALT_KEYS from .env and try again"
|
||
exit 1
|
||
fi
|
||
fi
|
||
|
||
# Insights's AI features (the Max assistant, SQL/regex assist) run on your own LLM provider key.
|
||
# If none is configured yet, offer to add one. Existing keys are never touched β we only append
|
||
# when the key is absent, so this is safe to run on every upgrade.
|
||
# Only prompt on an interactive terminal so a non-interactive upgrade doesn't block on stdin.
|
||
# Match `KEY=<value>` (note the trailing `.+`): a blank `KEY=` counts as missing, so a user who
|
||
# skipped the key at install still gets prompted. Read silently (-s) β these are secrets.
|
||
if [ -t 0 ] && ! grep -qE "^ANTHROPIC_API_KEY=.+" .env; then
|
||
echo ""
|
||
echo "Insights AI runs on an Anthropic API key, which isn't configured yet."
|
||
read -rsp "Enter an Anthropic API key to enable Insights AI (leave blank to skip): " ANTHROPIC_API_KEY_INPUT
|
||
echo
|
||
if [ -n "$ANTHROPIC_API_KEY_INPUT" ]; then
|
||
echo "ANTHROPIC_API_KEY=$ANTHROPIC_API_KEY_INPUT" >> .env
|
||
echo "Added ANTHROPIC_API_KEY to .env file"
|
||
fi
|
||
fi
|
||
if [ -t 0 ] && ! grep -qE "^OPENAI_API_KEY=.+" .env; then
|
||
read -rsp "Enter an OpenAI API key to enable SQL and regex AI assist (leave blank to skip): " OPENAI_API_KEY_INPUT
|
||
echo
|
||
if [ -n "$OPENAI_API_KEY_INPUT" ]; then
|
||
echo "OPENAI_API_KEY=$OPENAI_API_KEY_INPUT" >> .env
|
||
echo "Added OPENAI_API_KEY to .env file"
|
||
fi
|
||
fi
|
||
|
||
# Check if session recording storage migration marker exists
|
||
if ! grep -q "SESSION_RECORDING_STORAGE_MIGRATED_TO_SEAWEEDFS" .env; then
|
||
echo ""
|
||
echo ""
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo "π¦ SESSION RECORDING STORAGE UPDATE"
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo ""
|
||
echo "Insights now uses SeaweedFS for session recording storage."
|
||
echo "Your existing session recordings are stored in MinIO."
|
||
echo ""
|
||
echo "You have TWO options:"
|
||
echo ""
|
||
echo "1. π MIGRATE your existing session recordings to SeaweedFS"
|
||
echo " - Keeps all your existing recordings accessible"
|
||
echo " - Run migration script after upgrade"
|
||
echo " - New recordings will be stored in SeaweedFS"
|
||
echo " - Migration is best-effort for hobby deployments; support is limited"
|
||
echo ""
|
||
echo "2. β οΈ ACCEPT DATA LOSS of existing session recordings"
|
||
echo " - Existing recordings will become inaccessible"
|
||
echo " - Only new recordings will be available"
|
||
echo " - Faster upgrade, no migration needed"
|
||
echo ""
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo ""
|
||
read -r -p "Do you want to MIGRATE existing session recordings? [y/N] " response
|
||
if [[ "$response" =~ ^([yY][eE][sS]|[yY])+$ ]]
|
||
then
|
||
echo ""
|
||
echo "β
You chose to MIGRATE existing recordings."
|
||
echo ""
|
||
echo "After the upgrade completes, run this command to migrate:"
|
||
echo ""
|
||
echo " ./bin/migrate-session-recordings-hobby"
|
||
echo ""
|
||
echo "Options:"
|
||
echo " --dry-run Preview what would be migrated"
|
||
echo " --resume Resume from last checkpoint if interrupted"
|
||
echo " --force Overwrite existing objects in destination"
|
||
echo " --workers <n> Number of concurrent workers (default: 5)"
|
||
echo ""
|
||
read -r -p "Press ENTER to acknowledge and continue..."
|
||
echo "SESSION_RECORDING_STORAGE_MIGRATED_TO_SEAWEEDFS=pending_migration" >> .env
|
||
else
|
||
echo ""
|
||
echo "β οΈ You chose to ACCEPT DATA LOSS."
|
||
echo "Existing session recordings will not be accessible after upgrade."
|
||
echo ""
|
||
read -r -p "Are you sure? This cannot be undone. [y/N] " confirm
|
||
if [[ "$confirm" =~ ^([yY][eE][sS]|[yY])+$ ]]
|
||
then
|
||
echo "SESSION_RECORDING_STORAGE_MIGRATED_TO_SEAWEEDFS=data_loss_accepted" >> .env
|
||
echo "β
Proceeding without migration."
|
||
else
|
||
echo "Upgrade cancelled. No changes made."
|
||
exit 1
|
||
fi
|
||
fi
|
||
source .env
|
||
fi
|
||
|
||
export INSIGHTS_APP_TAG="${INSIGHTS_APP_TAG:-latest-release}"
|
||
|
||
# Check if current compose file uses postgres:12-alpine (needs migration before upgrade)
|
||
if grep -qE 'postgres:12-alpine|postgres:12' insights/docker-compose.hobby.yml 2>/dev/null; then
|
||
echo ""
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo "π PostgreSQL 12 β 15 UPGRADE REQUIRED"
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo ""
|
||
echo "Your docker-compose stack is using postgres:12-alpine."
|
||
echo "The new Insights version requires PostgreSQL 15."
|
||
echo ""
|
||
echo "β οΈ This migration deletes data, and isn't tested in your envronment. Reject auto-update to receive manual upgrade instructions."
|
||
echo ""
|
||
read -r -p "Do you want to automatically upgrade PostgreSQL 12 β 15? [y/N] " pg_response
|
||
if [[ "$pg_response" =~ ^([yY][eE][sS]|[yY])+$ ]]; then
|
||
echo ""
|
||
echo "Step 1: Creating backup..."
|
||
BACKUP_FILE="backup_pg12_$(date +%Y%m%d_%H%M%S).sql.gz"
|
||
|
||
if ! docker-compose exec -T db pg_dumpall --clean -U insights | gzip > "$BACKUP_FILE"; then
|
||
echo "β Backup command failed!"
|
||
rm -f "$BACKUP_FILE"
|
||
exit 1
|
||
fi
|
||
|
||
if [ ! -f "$BACKUP_FILE" ]; then
|
||
echo "β Backup file was not created!"
|
||
exit 1
|
||
fi
|
||
|
||
BACKUP_SIZE_BYTES=$(stat -f%z "$BACKUP_FILE" 2>/dev/null || stat -c%s "$BACKUP_FILE" 2>/dev/null || echo "0")
|
||
if [ "$BACKUP_SIZE_BYTES" -lt 1000 ]; then
|
||
echo "β Backup file is too small (${BACKUP_SIZE_BYTES} bytes) - backup likely failed!"
|
||
echo " Expected at least 1KB for a valid PostgreSQL dump."
|
||
rm -f "$BACKUP_FILE"
|
||
exit 1
|
||
fi
|
||
|
||
if ! gunzip -t "$BACKUP_FILE" 2>/dev/null; then
|
||
echo "β Backup file is corrupted (gzip integrity check failed)!"
|
||
rm -f "$BACKUP_FILE"
|
||
exit 1
|
||
fi
|
||
|
||
BACKUP_SIZE=$(du -h "$BACKUP_FILE" | cut -f1)
|
||
echo "β
Backup complete and verified: $BACKUP_FILE ($BACKUP_SIZE)"
|
||
|
||
echo ""
|
||
echo "Step 2: Stopping docker-compose stack..."
|
||
docker-compose down
|
||
|
||
echo ""
|
||
echo "Step 3: Removing postgres-data volume..."
|
||
docker volume rm postgres-data || true
|
||
|
||
# Save backup filename to a flag file for restore after git pull
|
||
echo "$BACKUP_FILE" > .pg12_migration_pending
|
||
echo ""
|
||
echo "β
Backup saved. Continuing with Insights upgrade..."
|
||
echo " Data will be restored after the new database starts."
|
||
echo ""
|
||
else
|
||
echo ""
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo "Manual upgrade steps:"
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo ""
|
||
echo " 1. Backup:"
|
||
echo " docker-compose exec -T db pg_dumpall --clean -U insights | gzip > backup.sql.gz"
|
||
echo ""
|
||
echo " 2. Stop:"
|
||
echo " docker-compose down"
|
||
echo ""
|
||
echo " 3. Remove volume:"
|
||
echo " docker volume rm postgres-data"
|
||
echo ""
|
||
echo " 4. Upgrade Insights code (git pull - pulls postgres:15 compose files)"
|
||
echo ""
|
||
echo " 5. Start:"
|
||
echo " docker-compose up -d db"
|
||
echo ""
|
||
echo " 6. Restore:"
|
||
echo " gunzip -c backup.sql.gz | docker-compose exec -T db psql -U insights"
|
||
echo ""
|
||
echo " 7. Upgrade password to SCRAM-SHA-256:"
|
||
echo " docker compose exec -T db psql -U insights -c \"ALTER USER insights WITH PASSWORD 'insights';\" > /dev/null 2>&1"
|
||
echo ""
|
||
echo "Please complete the manual upgrade before continuing."
|
||
exit 1
|
||
fi
|
||
fi
|
||
|
||
# Async migrations only exist for upgrades from versioned releases (the last one
|
||
# targets Insights <= 1.49.99). Every versioned release ships insights/version.py and
|
||
# it was removed once Insights moved to continuous deployment, so its presence in the
|
||
# current checkout (inspected before git pull replaces it) tells us whether the
|
||
# async migrations check is needed. CHECK_ASYNC_MIGRATIONS=1/0 overrides either way.
|
||
ASYNC_MIGRATIONS_CHECK_NEEDED=FALSE
|
||
if [ -f insights/insights/version.py ]; then
|
||
ASYNC_MIGRATIONS_CHECK_NEEDED=TRUE
|
||
echo "Detected an old versioned Insights release ($(grep VERSION insights/insights/version.py || true)), the async migrations check will run"
|
||
fi
|
||
|
||
cd insights
|
||
git pull --prune
|
||
cd ../
|
||
|
||
# Redis containers consolidated: redis (6.2) removed, only redis7 (7.2) remains
|
||
if docker volume ls -q | grep -q '^redis-data$'; then
|
||
echo ""
|
||
echo "βΉοΈ Redis consolidated to single container (7.2). Old 'redis-data' volume can be removed:"
|
||
echo " docker volume rm redis-data"
|
||
echo ""
|
||
fi
|
||
|
||
# Download GeoLite2-City.mmdb if it doesn't exist
|
||
echo "Downloading GeoIP database file"
|
||
apt-get update &&
|
||
apt-get install -y --no-install-recommends curl ca-certificates brotli &&
|
||
mkdir -p ./share &&
|
||
if [ ! -f ./share/GeoLite2-City.mmdb ]; then
|
||
curl -L 'https://mmdbcdn.insights.net/' --http1.1 | brotli --decompress --output=./share/GeoLite2-City.mmdb &&
|
||
echo '{\"date\": \"'$(date +%Y-%m-%d)'\"}' > ./share/GeoLite2-City.json &&
|
||
chmod 644 ./share/GeoLite2-City.mmdb &&
|
||
chmod 644 ./share/GeoLite2-City.json
|
||
fi
|
||
|
||
# Upgrade Docker Compose to version 2.33.1
|
||
echo "Setting up Docker Compose"
|
||
sudo rm /usr/local/bin/docker-compose
|
||
sudo curl -L "https://github.com/docker/compose/releases/download/v2.33.1/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose || true
|
||
sudo chmod +x /usr/local/bin/docker-compose
|
||
|
||
rm -f docker-compose.yml
|
||
cp insights/docker-compose.base.yml docker-compose.base.yml
|
||
cp insights/docker-compose.hobby.yml docker-compose.yml.tmpl
|
||
cp insights/.env.services .env.services
|
||
envsubst < docker-compose.yml.tmpl > docker-compose.yml
|
||
rm docker-compose.yml.tmpl
|
||
|
||
docker-compose pull
|
||
|
||
RUN_ASYNC_MIGRATIONS_CHECK="$ASYNC_MIGRATIONS_CHECK_NEEDED"
|
||
if [[ "${CHECK_ASYNC_MIGRATIONS:-}" =~ ^([yY][eE][sS]|[yY]|1|[tT][rR][uU][eE])$ ]]; then
|
||
RUN_ASYNC_MIGRATIONS_CHECK=TRUE
|
||
elif [[ "${CHECK_ASYNC_MIGRATIONS:-}" =~ ^([nN][oO]|[nN]|0|[fF][aA][lL][sS][eE])$ ]]; then
|
||
RUN_ASYNC_MIGRATIONS_CHECK=FALSE
|
||
fi
|
||
|
||
# Mid pg12 -> pg15 migration the postgres volume is empty until data is restored
|
||
# after the stack restarts, so there is no async migration state to check yet.
|
||
if [ -f ".pg12_migration_pending" ]; then
|
||
RUN_ASYNC_MIGRATIONS_CHECK=FALSE
|
||
fi
|
||
|
||
if [ "$RUN_ASYNC_MIGRATIONS_CHECK" == 'TRUE' ]; then
|
||
echo "Checking if async migrations are up to date"
|
||
# The asyncmigrationscheck container has no depends_on, so bring up the data
|
||
# stores it needs before running it (a previously interrupted upgrade can leave
|
||
# the stack stopped). It reads async migration state from Postgres and boots the
|
||
# Django app, which connects to Redis and Datastore. We deliberately avoid a
|
||
# full `up -d` so the web container doesn't run its migrate entrypoint first.
|
||
sudo -E docker-compose up -d db redis7 datastore
|
||
sudo -E docker-compose run --rm asyncmigrationscheck
|
||
else
|
||
echo "Skipping async migrations check, it's only needed when upgrading from a versioned release (set CHECK_ASYNC_MIGRATIONS=1 to force it)"
|
||
fi
|
||
|
||
echo "Stopping the stack!"
|
||
docker-compose stop
|
||
|
||
# rewrite entrypoint
|
||
# TODO: this is duplicated from bin/deploy-hobby. We should refactor this into a
|
||
# single script.
|
||
cat > compose/start <<EOF
|
||
#!/bin/bash
|
||
./compose/wait
|
||
./bin/migrate
|
||
./bin/docker-server
|
||
EOF
|
||
|
||
if [ ${DOCKER_VOLUMES_MISSING} == 'TRUE' ];
|
||
then
|
||
echo ""
|
||
echo ""
|
||
echo "π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨"
|
||
echo "π¨π¨π¨π¨WARNING: LAST CHANCE TO AVOID DATA LOSS π¨π¨π¨"
|
||
echo "π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨π¨"
|
||
echo ""
|
||
echo ""
|
||
echo "Before we restart the stack, you should restore data you have backed up from the previous warning."
|
||
echo ""
|
||
echo ""
|
||
fi
|
||
|
||
read -r -p "Do you want to restart the Insights stack now ? (docker-compose up) [y/N] " response
|
||
if [[ "$response" =~ ^([yY][eE][sS]|[yY])+$ ]]
|
||
then
|
||
echo "OK, Restarting the stack!"
|
||
sudo -E docker-compose up -d
|
||
else
|
||
echo "OK, we are leaving the stack OFFLINE. Run 'sudo -E docker-compose up -d' when you are ready to start it."
|
||
exit
|
||
fi
|
||
|
||
# Restore PostgreSQL data if we did a pg12 -> pg15 migration
|
||
if [ -f ".pg12_migration_pending" ]; then
|
||
PG12_BACKUP_FILE=$(cat .pg12_migration_pending)
|
||
rm -f .pg12_migration_pending
|
||
|
||
echo ""
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo "π Restoring PostgreSQL data from backup"
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo ""
|
||
echo "Waiting for PostgreSQL 15 to be ready..."
|
||
sleep 20
|
||
|
||
echo "Restoring data from $PG12_BACKUP_FILE..."
|
||
if gunzip -c "$PG12_BACKUP_FILE" | docker-compose exec -T db psql -U insights; then
|
||
echo "β
Data restored successfully!"
|
||
|
||
echo ""
|
||
echo "Upgrading password to SCRAM-SHA-256..."
|
||
docker-compose exec -T db psql -U insights -c "ALTER USER insights WITH PASSWORD 'insights';" > /dev/null 2>&1
|
||
|
||
echo ""
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo "β
PostgreSQL 12 β 15 migration complete!"
|
||
echo "ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ"
|
||
echo ""
|
||
echo "Backup saved at: $PG12_BACKUP_FILE"
|
||
echo "You can delete it once you've verified everything works."
|
||
echo ""
|
||
else
|
||
echo "β Data restore failed!"
|
||
echo ""
|
||
echo "Your backup is saved at: $PG12_BACKUP_FILE"
|
||
echo ""
|
||
echo "To manually restore, run:"
|
||
echo " gunzip -c $PG12_BACKUP_FILE | docker-compose exec -T db psql -U insights"
|
||
echo ""
|
||
exit 1
|
||
fi
|
||
fi
|
||
|
||
echo "Consider running 'docker system prune -a' to clean up old images and free disk space"
|
||
echo "Insights upgraded successfully!"
|