managedb (873B) - Raw
1 #!/bin/bash 2 3 PATH=$PATH:/usr/lib/postgresql/12/bin 4 case ${1:-} in 5 init) 6 mkdir -p db && initdb db 7 mkdir -p db/wal 8 sed -i "s/.*unix_socket_dir.*/unix_socket_directories = '.\/wal'/" \ 9 db/postgresql.conf 10 pg_ctl -D db -l db/logfile start 11 12 export PGHOST=127.0.0.1 13 psql postgres -c 'CREATE ROLE osm WITH SUPERUSER LOGIN' 14 psql postgres -c 'CREATE DATABASE osm' 15 psql osm osm -c 'CREATE EXTENSION postgis' 16 ;; 17 start) 18 pg_ctl -D db -l db/logfile start 19 ;; 20 stop) 21 pg_ctl -D db -l db/logfile stop 22 ;; 23 "" | --) 24 [[ $# -gt 1 ]] && shift 25 exec env \ 26 PGHOST=127.0.0.1 \ 27 PGUSER=osm \ 28 PGDATABASE=osm \ 29 psql "$@" 30 ;; 31 *) 32 >&2 echo "Unknown command: '$*'" 33 exit 1 34 ;; 35 esac