Download Physical Backup

Hello everyone, I have some issues that need to be checked. A few customers noticed misalignment in the data between today and few days ago. I want to download the physscal backup to check if they're correct and if there're any glitch in the platform. I saw there's this command: npx supabase@beta backups list to list the available backups, but how to I download them? I don't want to restore because this would cause data loss.
8 Replies
garyaustin
garyaustin3w ago
You can restore to another project with a physical backup.
lucas tiberio
lucas tiberioOP3w ago
hmm I see, then I can restore in the duplicated project and connect in the db, right?
garyaustin
garyaustin3w ago
Sorry, I've not used it. I believe it creates a copy of your current project to another one and then you can access that.
lucas tiberio
lucas tiberioOP3w ago
ya, I'll let you know if it doesn't duplicate the backups, ty sir
garyaustin
garyaustin3w ago
You are supposed to be able to pick one of your physical backups or pitr backup if you have those.
lucas tiberio
lucas tiberioOP3w ago
Yeah it worked, we had to pay $15 to duplicate tho. Is downloading physical backups something in the supabase pipeline?
garyaustin
garyaustin3w ago
You are billed hourly or some such if you put the instance in the same Pro org. Then you can kill it when you've dumped a copy to a local postgres yourself or found what you are looking for. No one here can tell you what is in their pipeline. This is mainly a user helping user forum.

Did you find this page helpful?