Avoid a big-bang cutover. Keep using Postgres while replacing unsupported types with Active Record custom types, adopting Solid Stack gems (whose SQLite files live alongside Postgres), and dropping/rewriting Postgres-specific check constraints. Deploy each step to staging, test it, and only then swap the database adapter and run the data migration script. Every step remains reversible.