Operations

Maintenance

When a new version is available, run:

./update.sh

The script performs the following steps:

  1. Pulls the latest Docker images

  2. Backs up the current volume data

  3. Starts Docker services

  4. Creates a database backup

  5. Runs database migrations

  6. Cleans up unused Docker resources

Backup Strategy

  • Daily automated database backups via pgbackups service

  • Volume data backup before updates

  • Retention policies:

    • 7 days of daily backups

    • 4 weeks of weekly backups

    • 6 months of monthly backups

The specifics can be adjusted in the docker-config file.

Backup Recovery

First, make sure there are no connections to the database by terminating all active connections

SELECT * FROM pg_stat_activity WHERE pg_stat_activity.datname='DataSpace';
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = 'DataSpace';

Then drop and recreate the database

DROP DATABASE "DataSpace";
CREATE DATABASE "DataSpace";

Finally, add the backup

zcat "/opt/dataspace/Platform/volume/DataSpace_db_backup/<choose_your_backup>.sql.gz" | psql --host="database" --username="postgres" --dbname="DataSpace" -W

Manual Service Management

# Start services
docker compose --file docker-compose.yml --env-file .env up -d

# Stop services
docker compose down

# View logs
docker compose logs -f

# Restart specific service
docker compose restart api
PreviousConfiguration

Last updated