mangeot/postgres4jibiki repository overview

Postgresql database set up for jibiki lexical resources management web server built upon Postgres alpine official image: https://hub.docker.com/_/postgres/⁠

docker pull mangeot/postgres4jibiki or docker build -t mangeot/postgres4jibiki github.com/mangeot/postgres4jibiki

docker run --name jibiki-database -d mangeot/postgres4jibiki postgres

To backup: docker exec -u postgres jibiki-database pg_dump jibiki > jibiki.sql

To drop db: docker exec -u postgres jibiki-database psql -c 'DROP DATABASE jibiki'

To restore: cat jibiki.sql | docker exec -i jibiki-database psql -U postgres

(don't know why but pg_restore hangs) docker exec -u postgres jibiki-database pg_restore -C -d jibiki < jibiki.sql