🌐 LAN Database Inventory

All databases across merlin-db.phoebe.lan, orcus.lan, du1, and du2

← Projects DATABASES.md Orcus Local View System Status

📁 Backup Consolidation

All backups are being consolidated to \atrium.lanackups-orcus with structure:

merlin-db.phoebe.lan PRIMARY DB
192.168.2.81 CT 304 (Phoebe LXC) PostgreSQL 16.13 SSH: ssh merlin-db
Database Type User Notes
merlin PostgreSQL merlin Main Merlin app DB (nodes, shares, files, jobs). Migrated from CT 303 (PG14) on 2026-02-28.
Connection: psql -h 192.168.2.81 -U merlin -d merlin • Web: http://merlin-db.phoebe.lan/ (local info page) • Full docs: DATABASES.md
orcus.lan LOCAL
192.168.2.32 Phoebe VM ~15 web apps
Database Type Owner/Location Backup Status
energystats PostgreSQL energystats ✗ No backup
philanthropy_planner PostgreSQL pp_user ✗ No backup
prospecta_cc PostgreSQL postgres ✗ No backup
zap PostgreSQL zap_user ✗ No backup
philonenic.db SQLite philoenic.com/database/ ✓ Daily (NAS)
zap-mail.sqlite SQLite zap-mail/db/ ✓ Daily (NAS)
concerts.db SQLite concerts.freebyrd.live/data/ ✓ Daily (NAS)
media-manager.db SQLite media-manager/private/ ⚠ Check backup
merlin.db SQLite merlin/data/ ⚠ Check backup
file-finder.sqlite SQLite file-finder/private/db/ ⚠ Check backup

📂 Backup Folders (click to open on Windows)

🗄️ PostgreSQL 🗄️ SQLite (orcus) 🗄️ SQLite (du1) 🗄️ SQLite (du2) 🗄️ System 🗄️ Full Dumps

💡 If links don't open, run backups-protocol-handler.reg on paris.lan (in your home directory)

du1.merlin-ai.com REMOTE PRODUCTION
161.35.36.240 DigitalOcean NYC SSH: jd@du1.merlin-ai.com
Database Type Owner/Path App
philanthropy_planner PostgreSQL pp_user philanthropy-planner.com
concerts.db SQLite /var/www/concerts.freebyrd.live/data/ concerts.freebyrd.live
Backup Status: Remote backups pulled to orcus, stored in \atriumackups-orcusackup-orcus
du2.merlin-ai.com REMOTE DEV/STAGING
142.93.45.250 DigitalOcean NYC SSH: jd@du2.merlin-ai.com
Database Type Owner/Path App
philoenic.db SQLite /var/www/dev.philoenic.com/database/ dev.philoenic.com
sso.db SQLite /var/www/dev.sso.merlin-ai.com/ dev.sso.merlin-ai.com
Backup Status: Remote backups pulled to orcus via /var/www/philoenic.com/cron/backup-db.sh dev