view prepare_psql.sh @ 20:c4607285ae18 draft

"planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 73142be24a0462a3aeb303401e8fcbc72f1cd4f5"
author gga
date Mon, 14 Mar 2022 14:56:59 +0000
parents 0e5b44c358d1
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'