lnls/docker-naming-service-postgres repository overview

⁠Docker Image for PostgreSQL

⁠Backup Instructions

On the running postgres container do:

    docker exec -t <your-db-container> pg_dumpall -c -U <db-user> > dump_naming-service-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 dockernamingservicecomposed_naming-service-postgres-volume --name naming-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_naming-service-postgres-<backup-date>.sql | docker exec -i naming-restore psql -U postgres

Cleanup temporary containers:

    docker stop naming-restore
    docker rm naming-restore