Mercurial > repos > gga > chado_analysis_add_analysis
annotate prepare_psql.sh @ 21:b07fc02bfe5d draft default tip
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 20d8d84d66eb27f870cadb94a02c97806090df24
| author | gga | 
|---|---|
| date | Wed, 11 May 2022 14:43:05 +0000 | 
| parents | 21de6e516f97 | 
| children | 
| rev | line source | 
|---|---|
| 10 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 1 #!/bin/bash | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 2 | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 3 export PWD=`pwd` && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 4 sed -i.bak "s|unix_socket_directories.*|unix_socket_directories = '$PWD/postgresql/'|" ./postgresql/db/postgresql.conf && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 5 | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 6 pglite start -d ./postgresql && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 7 | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 8 timeout 60 bash -c 'until pglite status -d ./postgresql | grep -F -q "server is running"; do sleep 1; done' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 9 pglite status -d ./postgresql && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 10 timeout 60 bash -c 'until ls -la ./postgresql | grep -F -q ".s.PGSQL.5432"; do sleep 1; done' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 11 pglite status -d ./postgresql && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 12 | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 13 echo "__default: local" > '.auth.yml' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 14 echo "local:" >> '.auth.yml' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 15 echo " dbhost: \"xxx\"" >> '.auth.yml' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 16 echo " dbname: \"xxx\"" >> '.auth.yml' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 17 echo " dbpass: \"xxx\"" >> '.auth.yml' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 18 echo " dbuser: \"xxx\"" >> '.auth.yml' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 19 echo " dbschema: \"$1\"" >> '.auth.yml' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 20 echo " dbport: \"xxx\"" >> '.auth.yml' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 21 echo " dburl: \"$(pglite url -d ./postgresql)\"" >> '.auth.yml' && | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 22 | 
| 
21de6e516f97
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 gga parents: diff
changeset | 23 export CHAKIN_GLOBAL_CONFIG_PATH='.auth.yml' | 
