MIGRATION INSTRUCTIONS

# PostgreSQL 17 → 18 Migration Instructions for LynxPrompt

## What the script does:
1. Creates timestamped backup directory
2. Dumps both databases from running v17 containers (in both custom and SQL formats)
3. Backs up the actual data directories
4. Stops old containers
5. Removes old data directories
6. Starts new PostgreSQL 18 containers (fresh initialization)
7. Restores all data from dumps
8. Verifies table counts
9. Starts all services

## To execute on watchtower:

### Option 1: Copy script and run manually