setup backup
We can replicate postgresql and use rsync to backup uploads.
Replication howto: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-on-postgresql-on-an-ubuntu-12-04-vps
We can use backup.poddery.com (we recently set it up for full backup of poddery.com). Any volunteers?
Pirate Praveen Mon 19 Sep 2016 5:15AM
Upgrade completed successfully. https://poddery.com/posts/2641176 Now going down for replication.
Pirate Praveen Mon 19 Sep 2016 7:10AM
Replication setup failed as master and slave cannot be on different architectures https://poddery.com/posts/2641320 :(
Pirate Praveen Mon 19 Sep 2016 8:33AM
Uploaded files are backed up using this cronjob now.
30 * * * * pgrep rsync || rsync -av --delete [email protected]:/usr/share/diaspora/public/uploads/ /var/lib/diasp.in/uploads/ >/var/lib/diasp.in/rsync-uploads.log
Pirate Praveen Mon 2 Jul 2018 7:54PM
@isaagar which server are we using for backup of uploads?
Pirate Praveen Mon 19 Sep 2016 8:39AM
We may be able to use a different solution like http://www.pgbackrest.org/ any volunteers to try it?
Pirate Praveen Fri 20 Jan 2017 1:55PM
We need to find another server with 64 bit Intel/AMD architecture to proceed. I recommend we go with a scaleway VC1S model (dual core 64 bit Intel VM with 2GB RAM). We can do a crowd funding to raise the amount, it comes to 2.99 Euro per month. If anyone has cheaper options to suggest, feel free.
@tvm @vik @amardeepsingh @akshay @fayadfami @anisha @dhanesh95
Dhanesh B. Sabane Fri 20 Jan 2017 4:21PM
I'm a complete noob when it comes to servers, but I have a couple of friends and colleagues who might know something about it. If in case I get some useful information, I'll immediately share it here.
Pirate Praveen Fri 20 Jan 2017 5:27PM
Everyone starts as a noob :) If there is interest you can master the servers.
Pirate Praveen Sun 22 Jan 2017 3:48PM
@amardeepsingh last time when we met at Baga, Goa, we talked about a backup server we can use. @isaagar can you check with Amardeep and confirm? If not, we'll proceed with scaleway.com option.
Pirate Praveen · Mon 19 Sep 2016 4:00AM
As announced yesterday, https://poddery.com/posts/2639595 I will be updating postgres to 9.4 and then setting up replication.
I'll follow https://medium.com/@tk512/upgrading-postgresql-from-9-3-to-9-4-on-ubuntu-14-04-lts-2b4ddcd26535#.l0bk7ufl4
but use the backports repo I created at http://mahishasura.pxq.in/hamara/