Fix postgres collation version mismatch

fix-postgres-collation.sh

#!/bin/bash

# PostgreSQL connection parameters
PG_USER="postgres"
PG_HOST="localhost"
PG_PORT="5432"

# Get a list of databases
databases=$(psql -U $PG_USER -h $PG_HOST -p $PG_PORT -q -t -c "SELECT datname FROM pg_database")

# Iterate through each database and execute the command
for database in $databases; do
    echo "Refreshing collation version for database: $database"
    psql -U $PG_USER -h $PG_HOST -p $PG_PORT -d $database -c "REINDEX DATABASE $database"
    psql -U $PG_USER -h $PG_HOST -p $PG_PORT -d $database -c "ALTER DATABASE $database REFRESH COLLATION VERSION"
done