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

        Gliffy Diagrams

          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: