nub-project, mskytter+gbif - backup and restore

backup

backup-db:
	docker exec -it db \
		bash -c "pg_dump -U $(POSTGRES_USER) -d $(POSTGRES_DB) > /tmp/clb.sql"

restore-dyntaxa-dump:

	test -f clb.sql || curl -L --progress -o clb.sql \
		"https://nrmowncloud.nrm.se/owncloud/index.php/s/0tiY0uLW4wqQ9p7/download?path=%2F&files=clb_structure_and_data.dump"

	docker cp clb.sql db:/tmp/clb.sql

restore-db:

	docker exec -it db \
		psql -U $(POSTGRES_USER) -c "select pg_terminate_backend(pg_stat_activity.pid) from pg_stat_activity where datname = 'clb';"

	docker exec -it db \
		psql -U $(POSTGRES_USER) -c "drop database clb;"

	docker exec -it db \
		psql -U $(POSTGRES_USER) -c "create database clb;"

	docker exec -it db \
		psql -U $(POSTGRES_USER) -d $(POSTGRES_DB) -f /tmp/clb.sql