Database backups

The current process for backing up the Seshat database is as follows:

1. ssh into the server hosting the database e.g. seshat-db.com (see websites):

   ssh user@server
   

2. Create a dumpfile backup of the PostgreSQL database, where <seshat_db_name> is the name of the database and <date> is the current date:

   pg_dump -U postgres -d <seshat_db_name> > backup_<date>.dump
   

3. Download the dumpfile to your local machine:

   scp user@server:/path/to/backup_<date>.dump /path/to/backup_<date>.dump
   

4. Upload the dumpfile to this google drive folder.