FAQ | This is a LIVE service | Changelog

Skip to content
Snippets Groups Projects
  1. May 24, 2024
    • Dr Catherine Pitt's avatar
      Add -q flag to psql calls to suppress 'INSERT 0 1' etc · 59d01a57
      Dr Catherine Pitt authored
      Closes #6
      
      When running psql commands to insert rows in the database, psql normally
      returns an message about what it did, eg "INSERT 0 1" if it inserted a
      row. This can be suppressed with -q . Several of the scripts use psql
      commands to get primary keys from the database, inserting the row if
      necessary. This can lead to the host id variable in the script being set
      to 'INSERT 0 1 <thehostid>' which causes problems when this variable is
      used in other SQL commands.
      
      This always used to work; I suspect the thing that changed is our
      upgrading to Postgres 16 on the backup servers, but I'm struggling to
      see how as Postgres 13 seems to behave the same for me.
  2. Jun 29, 2021
    • Dr Catherine Pitt's avatar
      Add an outline script for moving a whole zpool · 7ae60f97
      Dr Catherine Pitt authored
      This came about because a disk has failed on nest-backup, which only has
      subdirectory backups of nest-filestore-0 and so move-machine.sh was not
      going to be helpful - it assumes all tasks for a machine are on the same
      zpool which isn't true there. In this case I did the move by hand, but
      have sketched out the steps in the script in the hope that next time we
      have to do this we'll do it by looking at the script and running bits by
      hand, then improve the script a bit, and continue until it's usable.
      7ae60f97
Loading