setup backup
Pirate Praveen PublicSeen by 21We 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?
Sorry for the delay , I will post about it after fixing replication.
Just to confirm, are we using the NAT VPS I provided? If so, did you face any issues with the common ports not reaching the VPS?
Unable to telnet port 11234 which is used by postgresql .
I re-issued backup commands and replication is now working fine.
@praveenarimbrathod Also , using uptimerobot I dont think its possible to check psql replication . I think we need to run custom script at master server for checking status..
With poddery.com, the slave server was going down unnoticed and breaking replication so added uptimerobot check to know if mysql slave is running. We can do a similar one here. Its not perfect monitoring, but better than not having any :) We can add more for sure.
In one case , I noticed that slave server was running at mayasura but with broken replication and I need to restart slave server to accept data segments from master server .
I think we need better solution for this case.
Still ,we haven't decided for the monitoring part . Zabbix is used at TBS for monitoring purposes which can solve our problem.
If we can use the same zabbix instance, we can configure zabbix for monitoring.
@praveenarimbrathod Uploads aren't backed up yet.I think @tvm provided extra disk on mayasura. Will try to do it over weekend
Do we need an action here? I'm ready to volunteer for the work. Will be needing some guidance though.
Also please post an update about the backup setup from diasp.in diaspora account.