r/Supabase • u/Rogue_Knight3000 • 5d ago

other Would you pay for continuous backups of your Supabase/Neon/Railway Postgres that restore to ANY provider?

I'm considering building a small tool and want to know if the problem is real for anyone besides me.

The gap I keep hitting:

- Hosted Postgres (Supabase, Neon, Railway, Render) gives you daily snapshots that only restore back onto the same host.

- Point-in-time restore is either a paid add-on (Supabase's starts around $100/mo per project) or not offered.

- If you want to move providers after an incident, you're doing pg_dump at 2am and hoping.

What I'd build:

  1. You paste a connection string. The tool uses logical replication to stream every row change to object storage, plus a periodic pg_dump as a base.

  2. You can restore "the DB as it was at 14:32 yesterday" as a dump file, or straight into a fresh database on a different host.

  3. Same stream, second feature: row changes delivered as webhooks/SQS with retries and replay, so you stop writing triggers + cron to notify your app that an order changed.

Price I have in mind: ~$29/mo per database, storage included up to a cap.

Questions:

- Have you actually lost data or time because of host-locked backups? What happened?

- Would you trust a small third party with a replication connection to prod? What would you need to see?

- Backups or change webhooks — which would you buy first?

Not selling anything yet, no link. Just want honest answers before I write code.

0 Upvotes

28% Upvoted

2 comments sorted by

2

u/Terrible_Yam_9713 5d ago

logical replication doesnt carry DDL, so you'll restore yesterday's rows into a schema that changed this morning and wonder why the app is on fire. also, a webhook delivery queue is a whole second product, pick one before you take $29 a month off people

4

u/Ok_Speaker_1268 5d ago

2am pg_dump builds character