automatic backups for postgresql databases using google/zx

backup.mjs

#!/usr/bin/env zx

await cd('BACKUP FOLDER')
let files = await $`ls`

let min = 0
files.stdout.split("\n").forEach(file => {
    let fileNumber = Number.parseInt(file.split(".")[0], 10)
    if (fileNumber > min) {
        min = fileNumber
    }
})

let fileNameNumber = String(min+1).padStart(4, "0")
await $`pg_dump -d DATABASE -h localhost -U USERNAME -Z 9 -f ${fileNameNumber}.sql.gz`