I Moved 7 Side Projects from AWS RDS to Free Postgres — My Bill Went from $47/Month to $0

说明与用途

将七个低流量项目从 AWS RDS 迁移到免费 PostgreSQL 主机（Neon、Supabase、Turso），将每月费用从 47 美元降至 0 美元，年节省 571 美元。

问题

Seven low‑traffic side projects were each paying $6‑$8/month on AWS RDS, totaling $47/month for less than 130 daily requests.

结果

Migrated 7 projects for $0/month, saving $571/year, with 100% uptime and minimal downtime.

工作流

• 1. Inventory projects and their DB sizes, request rates, and RDS costs.
• 2. Choose target provider: Neon for fast wake, Supabase for auth, Turso for read‑heavy workloads.
• 3. Create migration script using pg_dump/pg_restore with --no-owner, --no-privileges, --no-tablespaces.
• 4. Run script for each project, adjusting SOURCE and TARGET URLs.
• 5. Resolve provider‑specific gotchas (Neon autosuspend, Supabase pooler, Turso SQLite limitations).
• 6. Verify row counts and uptime after migration.
• 7. Monitor costs and performance for 30 days.
• 8. Document savings and lessons learned.

证据

Total: $0/month. Savings: $571/year.

来源

Neon autosuspend kills long queries.

来源

Supabase pooler drops idle connections.

来源

Turso is SQLite, not Postgres.

来源