CalCOFI / server

calcofi.io server setup for R Shiny apps, RStudio IDE, R Plumber API, temporary PostGIS database, pg_tileserv
MIT License
0 stars 0 forks source link

+ db backup #8

Open bbest opened 7 months ago

bbest commented 7 months ago

Add container to docker-compose.yml borrowing from one of these:

Save backups to /share on the VM instance and setup /share as a separate mounted volume with snapshots taken daily.

Hold the phone -- we got backups as of today (2024-03-12):

cd /share/db_backup
ls
gis_2024-02-12.dump  gis_2024-02-20.dump  gis_2024-02-28.dump  gis_2024-03-07.dump
gis_2024-02-13.dump  gis_2024-02-21.dump  gis_2024-02-29.dump  gis_2024-03-08.dump
gis_2024-02-14.dump  gis_2024-02-22.dump  gis_2024-03-01.dump  gis_2024-03-11.dump
gis_2024-02-15.dump  gis_2024-02-23.dump  gis_2024-03-04.dump  gis_2024-03-12.dump
gis_2024-02-16.dump  gis_2024-02-26.dump  gis_2024-03-05.dump
gis_2024-02-19.dump  gis_2024-02-27.dump  gis_2024-03-06.dump