DBA Guide

This DBA guide provides documentation on how to manage the database. See also Schema Maintenance Guide.

Database Setup

Follow the README installation instructions for database setup: README

Backup the database

Backup the database with this command:

$ pg_dump --encoding utf8 cia_dev -f cia_dev.sql

Restore the database

Restore the database with this command:

$ psql -f cia_dev.sql -d cia_dev

Schema Documentation

• Entity Model: Hibernate Entity Model
• Database Docs: Liquibase Database Documentation
• Data Model: Data Model Documentation

PostgreSQL Extensions

The application requires the following PostgreSQL extensions:

• pg_stat_statements - Query statistics
• pgaudit - Audit logging
• pgcrypto - Cryptographic functions