[SAC] [OSGeo] #2041: Set up backup routine for staging.www.osgeo.org

#2041: Set up backup routine for staging.www.osgeo.org
---------------------------+-------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone: Website rebranding 2017
Component: Systems Admin | Keywords:
---------------------------+-------------------------------------
The new beta website server

staging.www.osgeo.org

is not yet in our backup routine and needs to be especially when people
start doing some serious editing.

I assume we need to setup Bacula but not sure the details of that.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2041&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2041: Set up backup routine for staging.www.osgeo.org
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------

Comment (by strk):

Reference wiki page about Bacula: https://wiki.osgeo.org/wiki/SAC:Bacula
It would be good to also refresh/renew that page if needed

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2041#comment:1&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2041: Set up backup routine for staging.www.osgeo.org
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------

Comment (by martin):

I've set up a first shot at backing up the staging machine,

Martin.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2041#comment:2&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2041: Set up backup routine for staging.www.osgeo.org
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+--------------------------------------

Comment (by robe):

I just added a cronjob to backup the database and website nightly to
folder /var/www/backups.

I presume that folder will be picked up by Bacula based on the above link
strk provided.

I feel this is necessary in case someone makes a mistake midday to a table
or entry and needs to pull a record from old database. Much easier too
from SQL backup than the actual mysql db files.

I have the database rotate daily (keep 7 days) but only one website backup
since it's about 1.5GB.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2041#comment:3&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.

#2041: Set up backup routine for staging.www.osgeo.org
---------------------------+--------------------------------------
Reporter: robe | Owner: sac@…
     Type: task | Status: closed
Priority: major | Milestone: Website rebranding 2017
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+--------------------------------------
Changes (by robe):

* status: new => closed
* resolution: => fixed

Comment:

I think we are done enough with this. Closing it out.

--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/2041#comment:4&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.