Development: document --backupdb argument and load db data from dump

[humitos]

I've been using the --backupdb when running migrate (inv docker.manage --backupdb migrate) and today I needed the dump to go back to an old db state. I followed these steps:

inv docker.compose 'start database'
docker cp dump.sql community_database_1:/tmp/dump.sql
inv docker.shell --container database

$ dropdb -U docs_user docs_db
$ createdb -U docs_user docs_db
$ psql -U docs_user docs_db < /tmp/dump.sql

We should document this in https://docs.readthedocs.io/en/stable/development/standards.html

[humitos]

This could probably an invoke task called restoredb or simliar that executes all those commands automatically:

inv docker.restoredb --file dump_04-01-2021_15_46_55__d6c5948d38590d64e82088670c1e8a4ff430a41d.sql

[vitorsv1]

Hi @humitos ! I'm working on it 😄

[vitorsv1]

Please ignore the second mentioned to this issue 😢