Uploaded image for project: 'JikesRVM'
  1. JikesRVM
  2. RVM-130

Perform Backups of CatTrack database

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Infrastructure
    • Labels:
      None

      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

        Attachments

          Activity

          Hide
          pdonald 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
          pdonald 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
          dgrove David Grove added a comment -

          Implemented by Daniel a long time ago...

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

            People

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

              Dates

              • Created:
                Updated:
                Resolved: