sarah, 15 days 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, 14 days 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, 14 days 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, 13 days 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, 13 days 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, 15 days ago @sarah SnapShooter. Works great imo and very reasonably priced.
@sarah SnapShooter. Works great imo and very reasonably priced.
ghostwriter, 15 days 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, 15 days 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, 15 days 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, 15 days 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