This page explains some useful commands for administering the production server.
38. Server¶
38.1 Restart Server¶
Note: Please don't restart server frequently, as we don't have any backup server yet.
If a change is made and it requires to restart the server, there are 2 ways (depends on the scope of the changes):
- Go to /home/web/catalogue/deployment
and type: make reload
.
This command will restart uwsgi container.
If the changes don't immediately take place, try this command:
docker-compose -p catalogue restart uwsgi
docker-compose -p catalogue up -d web
This will restart the web server (nginx and uwsgi containers).
39. Database¶
39.1 Database Container¶
If for some reasons you need to go to the database via a terminal, you can do:
- Go to /home/web/catalogue/deployment
- Type: make dbshell
- Type docker when asking a password
- You are already inside the database container.
39.2 Database Backup Files¶
The database is backed up daily at 00.00 AM.
The location of the backup files is /home/web/catalogue/deployment/backups
.
The backup file naming convention is PG_catalogue_gis.<date_of_backup>.dmp
.
The backup files is stored based on year and month folders.
Suppose you are looking for a last backup file dated on 3 March 2017, then you can find the backup file under /home/web/catalogue/deployment/backups/2017/March
folder.
From this folder, you should expect a file called PG_catalogue_gis.03-March-2017.dmp
.