The goal of this article is to help setup the various backup / restore solutions for this project.

While you are on the CentOS 7 server, please login as the administrator and then run the following in your console:

1. Go inside postgres.

su - postgres

2. Export out database.

pg_dump -U postgres -d academicstoday_db > academicstoday_db.backup

3. Exit postgres.

exit

4. Move our export to our django user.

mv /var/lib/pgsql/academicstoday_db.backup /home/techops/academicstoday_db.backup

5. Delegate authority for the administrator to manage the exported database.

chown techops /home/techops/academicstoday_db.backup;
chgrp techops /home/techops/academicstoday_db.backup;

6. Log in as the administrator and confirm the database export was successful.

su - techops
cd ~/
ls -alh

7. Congradulations you've exported a copy of the database.

The following instructions will work Linux or MacOS.

1. Download the database (Mac/Linux)

scp -i ~/.ssh/id_rsa [email protected]:/home/techops/academicstoday_db.backup /var/tmp

2. Congradulations you've saved a copy of the database onto your local machine.

3. Confirm your copy.

ls -alh /var/tmp

1. Load up the postgres app (we are assuming you are running Postgres.app) and run the following. Please ensure you do not run the drop command in your production environment!

drop database academicstoday_db;
create database academicstoday_db;

2. Open Terminal and run the following:

psql -U django academicstoday_db < /var/tmp/academicstoday_db.backup;

3. Congradulations you've restored the production environment data onto your local machine. Now before you run your application, please run the following backfill command.

(env)$ python manage.py backfill