view deploy/provision.d/080-database-load.sh @ 1628:9c5f8e24dadc live tip

Quieten this cron script
author Chris Cannam
date Tue, 25 Aug 2020 11:38:49 +0100
parents 89d3095ddc70
children
line wrap: on
line source
#!/bin/bash

set -e

# Start the database and if a dump file is found, load it. The dump
# file is then deleted so that the db won't be overwritten on
# subsequent runs. (The original repo contains no dump file, so it
# should exist only if you have provided some data to load.)

/etc/init.d/postgresql start

dumpdir="/code-to-deploy"
if [ ! -d "$dumpdir" ]; then
    dumpdir=/var/www/code
fi

cd "$dumpdir"

if [ -f postgres-dumpall ]; then
    chmod ugo+r postgres-dumpall
    sudo -u postgres psql -f postgres-dumpall postgres
    rm postgres-dumpall
fi