[SAC] [OSGeo] #2217: No per day backup of OSGeo database

#2217: No per day backup of OSGeo database
---------------------------+-------------------
Reporter: cvvergara | Owner: sac@…
     Type: task | Status: new
Priority: major | Milestone:
Component: Systems Admin | Keywords:
---------------------------+-------------------
From the backup directory

{{{
ls -la osgeo_*
-rw-r--r-- 1 robe users 4350437 May 11 23:05 osgeo_180511.sql.gz
-rw-r--r-- 1 root root 3889728 Mar 25 2018 osgeo_2018030.sql.gz
-rw-r--r-- 1 root root 3889728 Mar 26 2018 osgeo_2018031.sql.gz
-rw-r--r-- 1 root root 3889728 Mar 27 2018 osgeo_2018032.sql.gz
-rw-r--r-- 1 root root 3889728 Mar 28 2018 osgeo_2018033.sql.gz
-rw-r--r-- 1 root root 3889728 Mar 29 2018 osgeo_2018034.sql.gz
-rw-r--r-- 1 root root 3889728 Mar 30 2018 osgeo_2018035.sql.gz
-rw-r--r-- 1 root root 3889728 Mar 31 2018 osgeo_2018036.sql.gz
-rw-r--r-- 1 root root 3889728 Apr 1 2018 osgeo_2018040.sql.gz
-rw-r--r-- 1 root root 4263575 Apr 23 2018 osgeo_2018041.sql.gz
-rw-r--r-- 1 root root 3889728 Apr 3 2018 osgeo_2018042.sql.gz
-rw-r--r-- 1 root root 3889728 Apr 4 2018 osgeo_2018043.sql.gz
-rw-r--r-- 1 root root 3889728 Apr 5 2018 osgeo_2018044.sql.gz
-rw-r--r-- 1 root root 3889728 Apr 6 2018 osgeo_2018045.sql.gz
-rw-r--r-- 1 root root 4172979 Apr 7 2018 osgeo_2018046.sql.gz
-rw-r--r-- 1 root root 4350637 May 11 23:23 osgeo_2018055.sql.gz
-rw-r--r-- 1 root root 4353463 May 12 17:00 osgeo_2018056.sql.gz
-rw-r--r-- 1 root root 4812075 Jul 30 17:00 osgeo_2018071.sql.gz
-rw-r--r-- 1 root root 4819277 Jul 31 17:00 osgeo_2018072.sql.gz
-rw-r--r-- 1 root root 4849352 Aug 12 17:00 osgeo_2018080.sql.gz
-rw-r--r-- 1 root root 4886267 Aug 16 17:00
osgeo_20180816_before_gravity_forms_upgrade.sql.gz
-rw-r--r-- 1 root root 4858240 Aug 13 17:00 osgeo_2018081.sql.gz
-rw-r--r-- 1 root root 4868315 Aug 14 17:00 osgeo_2018082.sql.gz
-rw-r--r-- 1 root root 4873122 Aug 15 17:00 osgeo_2018083.sql.gz
-rw-r--r-- 1 root root 4886283 Aug 17 17:00 osgeo_2018085.sql.gz
-rw-r--r-- 1 root root 4881750 Aug 11 17:00 osgeo_2018086.sql.gz
-rw-r--r-- 1 root root 5186822 Sep 26 17:07 osgeo_2018093.sql.gz
-rw-r--r-- 1 root root 5186822 Sep 27 17:00 osgeo_2018094.sql.gz
-rw-r--r-- 1 root root 26077219 Jun 9 00:16 osgeo_daily_180608.sql
-rw-r--r-- 1 root root 762652782 Aug 16 17:01
osgeo_wp_180816_before_gravity_forms_upgrade.tar.gz
-rw-r--r-- 1 root root 824041645 Nov 8 17:01 osgeo_wp_daily.tar.gz
}}}
Looks like its not backing per day

I guess this is the daily backup
{{{
-rw-r--r-- 1 root root 824041645 Nov 8 17:01
osgeo_wp_daily.tar.gz
}}}

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

#2217: No per day backup of OSGeo database
---------------------------+-------------------
Reporter: cvvergara | Owner: robe
     Type: task | Status: new
Priority: major | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+-------------------
Changes (by robe):

* owner: sac@… => robe

Comment:

I'll take a look at it later today

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

#2217: No per day backup of OSGeo database
---------------------------+-------------------
Reporter: cvvergara | Owner: robe
     Type: task | Status: new
Priority: major | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+-------------------

Comment (by cvvergara):

osgeo_wp_daily.tar.gz is not the database backup

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

#2217: No per day backup of OSGeo database
---------------------------+-------------------
Reporter: cvvergara | Owner: robe
     Type: task | Status: new
Priority: major | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+-------------------

Comment (by robe):

Correct that's the website backup. The database backups were set to
rotate.

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

#2217: No per day backup of OSGeo database
---------------------------+-------------------
Reporter: cvvergara | Owner: robe
     Type: task | Status: new
Priority: major | Milestone:
Component: Systems Admin | Resolution:
Keywords: |
---------------------------+-------------------

Comment (by robe):

sorry was making backup in wrong place. I'll move them and the fix the
script.

-rw-r--r-- 1 0 0 178M Nov 8 17:00 foss4g2018_daily.sql
-rw-r--r-- 1 0 0 85K Nov 8 17:00 grass_staging_daily.sql
-rw-r--r-- 1 0 0 30M Nov 8 17:00 osgeo_daily.sql
-rw-r--r-- 1 0 0 30M Nov 8 17:00 staging_osgeo_daily.sql
}}}

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

#2217: No per day backup of OSGeo database
---------------------------+---------------------
Reporter: cvvergara | Owner: robe
     Type: task | Status: closed
Priority: major | Milestone:
Component: Systems Admin | Resolution: fixed
Keywords: |
---------------------------+---------------------
Changes (by cvvergara):

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

Comment:

Thanks

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