RVM
  1. RVM
  2. RVM-130

Perform Backups of CatTrack database

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Infrastructure
    • Labels:
      None
    • Number of attachments :
      0

      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

        Activity

        Hide
        Peter Donald added a comment -

        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=t
        gzip 9 cattrack_backup*.tar
        scp cattrack_backup-*.tar.gz somehost:somedir
        rm f cattrack_backup*.tar

        Unfortunately 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.

        Show
        Peter Donald added a comment - 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=t gzip 9 cattrack_backup *.tar scp cattrack_backup-*.tar.gz somehost:somedir rm f cattrack_backup *.tar Unfortunately 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.
        Hide
        David Grove added a comment -

        Implemented by Daniel a long time ago...

        Show
        David Grove added a comment - Implemented by Daniel a long time ago...

          People

          • Assignee:
            Unassigned
            Reporter:
            Peter Donald
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: