Backup and restore Postgres database

🐘 A Just recipe to back and restore a Postgres database by Jeff Triplett

# justfile
 
set DATABASE_URL := env_var_or_default('DATABASE_URL', 'postgres://postgres@db/postgres')
 
 
# dump database to file
@pg_dump file='db.dump':
    docker compose run \
        --no-deps \
        --rm \
        db \
        pg_dump \
            --dbname "{{ DATABASE_URL }}" \
            --file /code/{{ file }} \
            --format=c \
            --verbose
 
# restore database dump from file
@pg_restore file='db.dump':
    docker compose run \
        --no-deps \
        --rm \
        db \
        pg_restore \
            --clean \
            --dbname "{{ DATABASE_URL }}" \
            --if-exists \
            --no-owner \
            --verbose \
            /code/{{ file }}