Supabase Migration & RPC Integration

I’m ready to move an existing Supabase PostgreSQL database off the managed cloud and onto my own Linux-based VPS. The goal is to keep every feature my Flutter mobile app relies on—especially the Postgres functions it calls through RPC—while giving me full control of the server environment.

Scope of work
• Spin up and secure the Linux VPS (Ubuntu 22.04 is already provisioned, root access provided).
• Install the postgre db and make apis in node/go for working in the app
• Create custom backup/restore scripts, migrate the current data set, and verify integrity.
• Expose the same RPC endpoints my Flutter app consumes; connection strings and example calls will be supplied for testing.
• Harden the server (firewall, SSL/TLS, automatic backups) and document every step so I can reproduce it later.

Acceptance criteria
1. Flutter app compiles with the new base URL and all reads/writes over RPC succeed.
2. Database structure, roles, policies, and data match the original Supabase project.
3. Clean, commented migration scripts and a short README outlining how to re-run them or restore from backup.

If you have hands-on experience self-hosting Supabase or similar Postgres-based stacks and can get the hand-off done quickly, let’s talk.