Opened 9 years ago

Closed 8 years ago

#1702 closed defect (fixed)

backup pg on jepsonii

Reported by: weasel Owned by: weasel
Priority: Medium Milestone:
Component: Company Version:
Severity: Keywords:
Cc: erinn Actual Points:
Parent ID: Points:
Reviewer: Sponsor:

Description (last modified by weasel)

Hi helix,

I notice jepsonii has these files:

weasel@jepsonii:/srv/trac.torproject.org/trac/tor/db$ ls -la
total 191984
drwxr-sr-x 2 erinn tracadm 4096 Jul 19 15:20 ./
drwxrwsr-x 11 tracweb tracadm 4096 Jul 19 15:21 ../
-rw-r--r-- 1 erinn tracadm 26523873 Apr 23 08:35 postgres.21.1272011675.bak.gz
-rw-r--r-- 1 erinn tracadm 55822963 Jun 9 05:16 postgres.21.1276060556.bak.gz
-rw-r--r-- 1 erinn tracadm 55823056 Jun 9 05:19 postgres.21.1276060710.bak.gz
-rw-r--r-- 1 erinn tracadm 58190324 Jul 19 15:21 postgres.21.1279552818.bak.gz

It seems to me this is exactly what we want anyway. How did you cause these files to be created?

Child Tickets

Change History (4)

comment:1 Changed 9 years ago by weasel

Cc: erinn added
Description: modified (diff)

comment:2 Changed 9 years ago by phobos

if they are in /srv, they are automatically backed up.

comment:3 Changed 9 years ago by weasel

We use trac's dump feature to create daily backups to /srv/trac.tpo/DUMPS which then
gets picked up by rsnapshot.

Somebody should try to restore from one of these dumps.

comment:4 Changed 8 years ago by weasel

Resolution: fixed
Status: newclosed

we do filesystem backups, and we do streaming backups of pg. Things should be fine.

Note: See TracTickets for help on using tickets.