view prepare_psql.sh @ 15:c1b465401f8e draft

"planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit dc7fe1feecc587f7bc5d09108fbf016b0fd317bc"
author gga
date Mon, 18 Nov 2019 09:58:35 -0500
parents 9efb6d4ed19b
children
line wrap: on
line source

#!/bin/bash

export PWD=`pwd` &&
sed -i.bak "s|unix_socket_directories.*|unix_socket_directories = '$PWD/postgresql/'|" ./postgresql/db/postgresql.conf &&

pglite start  -d ./postgresql &&

timeout 60 bash -c 'until pglite status -d ./postgresql | grep -F -q "server is running"; do sleep 1; done' &&
pglite status -d ./postgresql &&
timeout 60 bash -c 'until ls -la ./postgresql | grep -F -q ".s.PGSQL.5432"; do sleep 1; done' &&
pglite status -d ./postgresql &&

echo "__default: local" > '.auth.yml' &&
echo "local:" >> '.auth.yml' &&
echo "    dbhost: \"xxx\"" >> '.auth.yml' &&
echo "    dbname: \"xxx\"" >> '.auth.yml' &&
echo "    dbpass: \"xxx\"" >> '.auth.yml' &&
echo "    dbuser: \"xxx\"" >> '.auth.yml' &&
echo "    dbschema: \"$1\"" >> '.auth.yml' &&
echo "    dbport: \"xxx\"" >> '.auth.yml' &&
echo "    dburl: \"$(pglite url -d ./postgresql)\"" >> '.auth.yml' &&

export CHAKIN_GLOBAL_CONFIG_PATH='.auth.yml'