#!/bin/bash
# Installs the daily PostgreSQL backup for PolyLLM on the deployment node (run ON the node).
set -euo pipefail
mkdir -p ~/backups/polyllm ~/Library/LaunchAgents
cat > ~/backups/polyllm/backup.sh <<'SH'
#!/bin/bash
set -euo pipefail
export PATH="/opt/homebrew/opt/postgresql@17/bin:/opt/homebrew/bin:$PATH"
out=~/backups/polyllm/polyllm-$(date +%Y%m%d).sql.gz
pg_dump polyllm | gzip -9 > "$out.tmp" && mv "$out.tmp" "$out"
find ~/backups/polyllm -name 'polyllm-*.sql.gz' -mtime +14 -delete
echo "$(date -Iseconds) ok $(du -h "$out" | cut -f1)" >> ~/backups/polyllm/backup.log
SH
chmod +x ~/backups/polyllm/backup.sh
cat > ~/Library/LaunchAgents/dev.polyllm.backup.plist <<PLIST
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0"><dict>
  <key>Label</key><string>dev.polyllm.backup</string>
  <key>ProgramArguments</key><array><string>/bin/bash</string><string>$HOME/backups/polyllm/backup.sh</string></array>
  <key>StartCalendarInterval</key><dict><key>Hour</key><integer>3</integer><key>Minute</key><integer>45</integer></dict>
  <key>StandardOutPath</key><string>$HOME/backups/polyllm/launchd.log</string>
  <key>StandardErrorPath</key><string>$HOME/backups/polyllm/launchd.log</string>
</dict></plist>
PLIST
launchctl bootout gui/$(id -u)/dev.polyllm.backup 2>/dev/null || true
launchctl bootstrap gui/$(id -u) ~/Library/LaunchAgents/dev.polyllm.backup.plist
~/backups/polyllm/backup.sh && echo "backup installed + first dump done"