Db backup restore - Githubissues

ubiquity / ubiquibot

Putting the 'A' in 'DAO'

https://github.com/marketplace/ubiquibot

MIT License

17 stars 61 forks source link

Db backup restore #877

Closed Keyrxng closed 1 year ago

Keyrxng commented 1 year ago

Resolves #865

Quality Assurance:

Considering this will be ran in a private repo, it was difficult to think of a way to showcase it and this was the best way I could think, mobile users beware.
I wasn't sure if you'd want to keep previous dumps so I've timestamped each and the restore action looks for dump files with no timestamp. I wasn't sure of a cleaner way to do this, I considered just backing up straight to another Supabase instance but this was there's a history of backups I guess.
Pushing the backup files you want to use into a branch called restore will restore things, I felt this was the cleanest way with my understanding that restores would rarely ever need to happen

Dump Commit

Dump commit

Restore Action

Restore action

Empty DB

empty-db

Restored DB

filled-db

netlify[bot] commented 1 year ago

Deploy Preview for ubiquibot-staging ready!

Name	Link
Latest commit	328dbd5a51096961b9fbd52ba5f78533c2b3955d
Latest deploy log	https://app.netlify.com/sites/ubiquibot-staging/deploys/654cbc035de8f80008657da4
Deploy Preview	https://deploy-preview-877--ubiquibot-staging.netlify.app
Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

To edit notification comments on pull requests, go to your Netlify site configuration.

rndquu commented 1 year ago

@Keyrxng What should be specified in the SUPABASE_DB_URL env variable? Connection URI like postgresql://postgres:[YOUR-PASSWORD]@db.qwerty.supabase.co:5432/postgres ?

rndquu commented 1 year ago

@Keyrxng What should be specified in the SUPABASE_DB_URL env variable? Connection URI like postgresql://postgres:[YOUR-PASSWORD]@db.qwerty.supabase.co:5432/postgres ?

@pavlovcik We need to set the SUPABASE_DB_URL env variable in this repo https://github.com/ubiquity/ubiquibot-db-backups to enable DB backups. You can either DM me the supabase DB password from the prod's DB either set the SUPABASE_DB_URL string yourself (this is basically a URI similar to postgresql://postgres:[YOUR-PASSWORD]@db.qwerty.supabase.co:5432/postgres)

0x4007 commented 1 year ago

I think I updated the environment variable correctly. However I had some authentication issues.

I sent you everything you need in a direct message in case this doesn't work.

github com_ubiquity_ubiquibot-db-backups_settings_secrets_actions