VPS to VPS Migration

Project Goal: Migrate an existing application environment from two current VPS instances to two new VPS instances with zero data loss and minimal downtime.

Current Infrastructure:
- Server 1 (Application): Next.js 14 (App Router), Edge Functions, Node.js environment.
- Server 2 (Database/Backend): Self-hosted Supabase stack (PostgreSQL, Auth, Realtime, etc.), Cron Jobs (pg_cron), and Webhook listeners.

Scope of Work:
- System Audit: Review current Docker Compose files and environment variables on both servers.
- Data Migration: Perform a safe migration of the PostgreSQL database and Supabase volumes from the old DB server to the new one.
- App Deployment: Re-deploy the Next.js 14 build and Edge runtime on the new App server.
- Configuration: Update all internal connections (API keys, DB URLs, and Webhook endpoints) to reflect the new server IPs.
- DNS & SSL: Point the domain to the new App server and ensure SSL certificates (Certbot/Nginx) are active.
- Testing: Verify that Cron Jobs and Database Webhooks are firing correctly in the new environment.

Technical Requirements:
- Expertise in Linux and Docker/Docker Compose.
- Specific experience with Self-Hosted Supabase (managing the multiple containers and volumes).
- Experience with PostgreSQL migration (pg_dump/restore or volume cloning).
- Familiarity with Next.js 14 deployment requirements.

Deliverables:
- A fully migrated and functional 2-server production environment.
- Updated documentation of any changes made to the environment variables or network config.