Skip to content

Backup ΒΆ

The primary database can be backed up over SSH to a local .sql file:

ssh admin@primary.db.indevets.com \
    sudo -u postgres pg_dumpall --clean \
        > /tmp/primary.$(date +"%Y-%m-%d_%H-%M-%S").sql

Or directly to a compressed .sql.bz2 file:

ssh admin@primary.db.indevets.com \
    sudo -u postgres pg_dumpall --clean \
| bzip2 \
> /tmp/primary.$(date +"%Y-%m-%d_%H-%M-%S").sql