Hello everyone!

I had a container with a DB crap itself yesterday so I’m trying to speed up my learning to back up stuff.

I came across a script that taught me how to back-up a containerized postgres db at given intervals and it works. I managed to create db dumps and restore them. I’ve documented everything and now my whole docker-compose/env etc are on git control.

There’s one part of the script I don’t decypher but I’d like to maybe change it. It is about the number of back-up copies.

Here’s the line from the tutorial: ls -1 /backup/*.dump | head -n -2 | xargs rm -f

Can someone explain to me what this line does? I’d like to keep maybe 3 copies just in case the auto-backup backs up a rotten one.

Thanks!

Full code below:

backup:
    image: postgres:13
    depends_on:
      - db_recipes
    volumes:
      - ./backup:/backup
    command: >
      bash -c "while true; do
        PGPASSWORD=$$POSTGRES_PASSWORD pg_dump -h db-postgresql -U $$POSTGRES_USER -Fc $$POSTGRES_DB > /backup/$$(date +%Y-%m-%d-%H-%M-%S).dump
        echo ""Backup done at $$(date +%Y-%m-%d_%H:%M:%S)""
        ls -1 /backup/*.dump | head -n -2 | xargs rm -f
        sleep 86400
      done"
  • klay@lemmy.world
    link
    fedilink
    English
    arrow-up
    4
    ·
    edit-2
    1 year ago

    Ah! This is a shell pipe! It’s composing several smaller commands together, cool stuff.

    • ls -1 is the grep-friendly version of ls, it prints one entry per line, like a shopping list.

    • head takes a set number of entries from the head of a list, in this case 2 items. negative two, meaning “all but the last two.”

    • xargs takes the incoming pipe and converts it into extra arguments, in this case applying those arguments to rm.

    So, combined, this says “list all the .dump files, pick the first two, all but the last two, and delete them.” Presumably the first are the oldest ones and the last are the newest, if the .dump files are named chronologically.