sarah, 1 month ago What do you use for offsite backups for #php applications and databases?
What do you use for offsite backups for #php applications and databases?
sarah, 1 month ago Thanks to everyone who replied. I’m looking for something that can basically export the db to sql and upload it to offsite backup storage. #php
Thanks to everyone who replied.
I’m looking for something that can basically export the db to sql and upload it to offsite backup storage. #php
mwop, 1 month ago @sarah I have a recurring job that (a) runs pgdump, and then (b) uses logrotate to rotate backups and expire old archives. This runs on a mounted s3fuse volume, which gives me backup to, in my case, DO spaces.
@sarah I have a recurring job that (a) runs pgdump, and then (b) uses logrotate to rotate backups and expire old archives. This runs on a mounted s3fuse volume, which gives me backup to, in my case, DO spaces.
willpower232, 1 month ago @mwop oh that's clever, I keep forgetting about fuse, are you using this one? https://github.com/s3fs-fuse/s3fs-fuse?tab=readme-ov-file
@mwop oh that's clever, I keep forgetting about fuse, are you using this one? https://github.com/s3fs-fuse/s3fs-fuse?tab=readme-ov-file
mwop, 1 month ago @willpower232 Yes, within a container, via elementary/s3-volume (https://github.com/elementar/docker-s3-volume).
@willpower232 Yes, within a container, via elementary/s3-volume (https://github.com/elementar/docker-s3-volume).
michael, 1 month ago @sarah SnapShooter. Works great imo and very reasonably priced.
@sarah SnapShooter. Works great imo and very reasonably priced.
ghostwriter, 1 month ago backup docker exec -t {app}postgres pg_dumpall -c -U postgres > backupdate +%Y-%m-%d"_"%H_%M_%S.sql upload to s3 aws s3 cp ./backups/ s3://backups/ --recursive --exclude * --include backup_*.sql download from s3 aws s3 cp s3://backups/backups_xyz.sql /backup.sql restore cat backup.sql | docker exec -i {app}_postgres psql -U postgres
backup
docker exec -t {app}postgres pg_dumpall -c -U postgres > backupdate +%Y-%m-%d"_"%H_%M_%S.sql
date +%Y-%m-%d"_"%H_%M_%S
upload to s3
aws s3 cp ./backups/ s3://backups/ --recursive --exclude * --include backup_*.sql
download from s3
aws s3 cp s3://backups/backups_xyz.sql /backup.sql
restore
cat backup.sql | docker exec -i {app}_postgres psql -U postgres
Skoop, 1 month ago @sarah containers in production, digital ocean spaces for uploaded files and managed databases
@sarah containers in production, digital ocean spaces for uploaded files and managed databases
pcambra, 1 month ago @sarah do you mean for storage? s3 or alike, wasabi for example
@sarah do you mean for storage? s3 or alike, wasabi for example
j3j5, 1 month ago @sarah I may be out of date here but I've been reliably using duplicity for the past +10 years and it's always worked great https://duplicity.us/
@sarah I may be out of date here but I've been reliably using duplicity for the past +10 years and it's always worked great
https://duplicity.us/
Add comment