Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Infrastructure
-
Labels:None
-
Number of attachments :
Description
There needs to be some backup policy put in place for the cattrack database on jikesrvm.anu.edu.au. This is probably as simple as using the "pg_dump" command to create a database backup and then scp'ing it to another host that is regularly backed up.
A possible pg_dump command could be something like the following
pg_dump --username cattrack cattrack --column-inserts --file=file.tar --blobs --no-privileges --format=t
What we want to do is
pg_dump -
username cattrack cattrack --column-inserts --file=cattrack_backup`date '+%Y%m%d%H%M'`.tar --blobs --no-privileges --format=tgzip
9 cattrack_backup*.tarscp cattrack_backup-*.tar.gz somehost:somedir
rm
f cattrack_backup*.tarUnfortunately it fails in the first step as it is out of disk space but looking at df seems to indicate that there is plenty of free space. So is there a quota per user or similar? If someone else could tackle this that would be great.