Operations

Maintenance

When a new version is available, run:

./update.sh

The script performs the following steps:

1

Pull latest Docker images

Pulls the latest Docker images.

2

Backup current volume data

Backs up the current volume data.

3

Start Docker services

Starts Docker services.

4

Create a database backup

Creates a database backup.

5

Run database migrations

Runs database migrations.

6

Cleanup unused Docker resources

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