what country is on the spot today
it is to complicated to know the world.
A better way to understand what's going on.
docker-compose up -d
docker exec -i newsroom_db psql -U newsroom newsroom < schema.sql
docker exec -i newsroom_db psql -U newsroom newsroom < countries.sql
to move to a production environment (without using the bundled docker-compose ) here are the action to step to follow:
Note: the following assumes that the user/pass for the new postres role is newsroom/newsroom
make docker-backup
backup docker database
docker exec -i newsroom_db pg_dump -U newsroom --clean --create --if-exists --no-owner --no-acl newsroom > thenewsroom-XXXXXXX_XXXX.dump.sql
done
$ sudo -u postgres psql
postgres=# create role newsroom with login createdb encrypted password 'newsroom';
CREATE ROLE
postgres=# \q
THIS OPERATION WILL OVERWRITE YOUR EXISTING DATABASE PROCEED WITH CAUTION
psql -U newsroom -h 127.0.0.1 -W template1 < thenewsroom-XXXXXXX_XXXX.dump.sql
$ pip install -r requirements.txt
0 */6 * * * theNewsroowmProduction.sh