Production databases

Prerequisites

• Basic understanding of Docker
• Good overview of c2c_org database schema
• and good knowledge of SQL

Connect to production server

ssh compose0.exoscale.infra.camptocamp.org
source /opt/c2corg-docker/server-list.env

Databases list

Each database is inside a docker container. You'll find two container :

• Main database: /opt/c2corg-docker/composition/production/postgresql-main/
• Backup database: /opt/c2corg-docker/composition/production/postgresql-backup/

If you need to update data in production, use the main database. Otherwise, for any read-only request, use the backup. Simply do cd <database_container_path>