START PROJECT

DEV DOCKER

sudo docker compose -f devops/docker/docker-compose.yml -f devops/docker/dev/docker-compose-dev.yml up --build -d

---

PROD DOCKER

sudo docker compose -f devops/docker/docker-compose.yml -f devops/docker/prod/docker-compose-prod.yml up --build -d

---

CERTBOT SSL

installing(Ubuntu/Debian):

sudo apt update
sudo apt install certbot python3-certbot-nginx

get certificate

sudo certbot certonly --webroot --webroot-path=/var/www/certbot -d your_domain.com --email your_mail@gmail.com --agree-tos --non-interactive --rsa-key-size 4096

REMOVE ALL MIGRATIONS

find . -path './*/migrations/*' ! -name '__init__.py' -type f -exec rm -f {} +

BACKUP DATABASE(POSTGRESQL)

create backup file

sudo docker exec -t postgres_container pg_dump -U username -d database_name -Fc --data-only -f /backup.dump

copy backup file to host

sudo docker cp postgres_container:/backup.dump ./backup.dump

restore backup file

docker exec -t postgres_container pg_restore -U username -d database_name --data-only ./backup.dump

restore data only table

docker exec -t postgres_container pg_dump -U username -d database_name -Fc --data-only -t table_name -f /backup.dump