lnls/docker-ccdb-postgres repository overview

⁠Docker Image for PostgreSQL with additions for CCDB service

⁠Backup Instructions

On the running postgres container do:

    docker exec -t <your-db-container> pg_dumpall -c -U <db-user> > dump_ccdb-postgres`date +%d-%m-%Y"_"%H_%M_%S`.sql

⁠Restore Instructions

Without any related containers running do:

    ./build-volume-postgres.sh

This will create data-only volumes and volume containers for restoring data.

Now, run a container mounting the recently create containers:

docker run -d -P --volumes-from dockerccdbcomposed_ccdb-postgres-volume --name ccdb-restore -v $(pwd):/var/lib/postgresql/backup postgres:9.5.4

Bear in mind that you must use the same postgres image version. Otherwise, postgres server will complain the versions are different on initialization

Finnaly restore the data by doing:

    cat dump_ccdb-postgres-<backup-date>.sql | docker exec -i ccdb-restore psql -U postgres

Cleanup temporary containers:

    docker stop ccdb-restore
    docker rm ccdb-restore