How to create SolusVM 2 database backup?

Question

How to create SolusVM 2 database backup?

Answer

1. Connect to SolusVM 2 management node via SSH

2. Run the command:

   # docker exec -it $(docker ps -q -f name=solus_postgres | head -n1) pg_dump -U$(docker exec $(docker ps -q -f name=solus_postgres | head -n1) env | grep POSTGRES_USER | awk -F "=" {'print $2'}) $(docker exec $(docker ps -q -f name=solus_postgres | head -n1) env | grep POSTGRES_DB | awk -F "=" {'print $2'}) > /path/to/solusvm2.sql

   where /path/to/solusvm2.sql - is path to the database dump

   # cat /path/to/solusvm2.sql | docker exec -i $(docker ps -q -f name=solus_postgres | head -n1) \ psql -U$(docker exec $(docker ps -q -f name=solus_postgres | head -n1) env | grep POSTGRES_USER | awk -F "=" '{print $2}') \ $(docker exec $(docker ps -q -f name=solus_postgres | head -n1) env | grep POSTGRES_DB | awk -F "=" '{print $2}')

   restore command