# Calckey backup scripts

## Introduction:

The bash files that create:

* A PostgreSQL database backup on a remote server
* The Calckey user /files/ directory
* A zipped archive of the above two

## Files:

The script to create a binary backup of the PostgreSQL database (needs .pgpass):

* ### [backup_calckey_db.sh]

The script to create a backup of the Calckey user /files/ directory that hold the 'Drive' files:

* ### [backup_calckey_files.sh]

The script to create an archive of the PostgreSQL database backup and the Calckey user /files/ directory backup:

* ### [backup_calckey_zipped.sh]

## .pgpass

Set up .pgpass to allow for postgres account authorisation without passing a password:

sudo nano /home/$USER/.pgpass

\#hostname:port:database:username:password

\*:\*:\*:ThePostgresAccount:ThePostgresAccountPassword

sudo chown $USER:$USER /home/$USER/.pgpass

chmod 600 /home/$USER/.pgpass

export PGPASSFILE='/home/$USER/.pgpass'

Check the enviroment variable has been set using:

env