/
Database backup - on demand

Database backup - on demand

Postgres

AWS

  1. Log in to AWS and open proper db via RDS > Databases

  2. Open Maintenance & backups > Snapshots > Take snapshot

  • Backups can be found in

    • RDS > Snapshots > Manual

    • RDS > Databases > “<RDS ID>“ > Maintenance & backups > Snapshots

CloudRanger

  1. Log in to cloud ranger and select proper account via top bar

  2. Open Resources > RDS section on left sidebar

  3. Select checkbox of RDS instance you want backup

  4. Click Options button above the table and click Take snapshot

Fig. 1
  • Backup might take some time (~15min for 70GB database)

  • Progress of backup is visible in both AWS and CloudRanger

  • Backups are stored in AWS and

    • have tag Created by application=CloudRanger

    • are marked as manual

DBeaver

  1. Using DBeaver connect with database

  2. In ‘Database Navigator’ select your database and click it with right mouse

  3. Choose Edit Connection and make sure that in ‘Main’ tab you have ‘Local Client’ selected (if not download postgres to your computer and add it)

  4. In you database go to ‘Databases’, select one and click it with right mouse

  5. Select ‘Tools > Backup’ option

  6. The window with selecting schemas and tables will pop up, select all which you are interested in and click ‘Start’ button

PGdump

TBD

Related content

How to set up the environment and debug application while creating mobile version
How to set up the environment and debug application while creating mobile version
Read with this
Postgres upgrade
Postgres upgrade
More like this
Proof of Concept: RapidPro integration
Proof of Concept: RapidPro integration
Read with this
Tips & Tricks
Tips & Tricks
More like this
UI Caching Design
UI Caching Design
Read with this
2019-02-14 Ghost Migration Notes
2019-02-14 Ghost Migration Notes
More like this

OpenLMIS: the global initiative for powerful LMIS software