Partially restore db backup

matthiasriener

PROOP

5 months ago

Hello, I accidentally dropped some data in a table in postgres. I do have a backup. Is it possible to restore specific tables and not the whole db? Thx

$10 Bounty

2 Replies

passos

MODERATOR

5 months ago

Hey, there's no built-in way to restore just a few tables, but when restoring from a backup, Railway creates a new volume for that restore. In theory, you could attach that volume to another Postgres service and then decide how to migrate only the data you want.

boymaas

PRO

5 months ago

I tried this, but when I restore the backup I always get an empty volume. Why is this the case?

Welcome!