How to backup and recover the analytics database

1. To take a DB dump:

pg_dump -U cloud9 -h 127.0.0.1 cloud9 > /tmp/analytics.dump

(provide the cloud9 password)

2. To restore a DB dump:

cd docker

(or where you have the docker-compose.yml file path)

docker-compose down

sudo su postgres

psql

DROP DATABASE cloud9;

CREATE DATABASE cloud9 with owner=cloud9;

exit

psql -U cloud9 -h 127.0.0.1 -d cloud9 < /tmp/analytics.dump

(provide the cloud9 password)

exit

docker-compose up -d