Loomio

setup backup

PP Pirate Praveen Public Seen by 21

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?

PP

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/

PP

Pirate Praveen Mon 19 Sep 2016 5:15AM

Upgrade completed successfully. https://poddery.com/posts/2641176 Now going down for replication.

PP

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 :(

PP

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

PP

Pirate Praveen Mon 2 Jul 2018 7:54PM

@isaagar which server are we using for backup of uploads?

PP

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?

PP

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

DBS

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.

PP

Pirate Praveen Fri 20 Jan 2017 5:27PM

Everyone starts as a noob :) If there is interest you can master the servers.

PP

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.

Load More