annotate prepare_psql.sh @ 18:883d296ab82c draft

"planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit de446b2959e55879a26948411adf6a22f1e3af3f"
author gga
date Fri, 30 Apr 2021 12:07:07 +0000
parents 9efb6d4ed19b
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
11
9efb6d4ed19b 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
9efb6d4ed19b planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
gga
parents:
diff changeset
2
9efb6d4ed19b 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` &&
9efb6d4ed19b 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 &&
9efb6d4ed19b planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
gga
parents:
diff changeset
5
9efb6d4ed19b 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 &&
9efb6d4ed19b planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
gga
parents:
diff changeset
7
9efb6d4ed19b 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' &&
9efb6d4ed19b 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 &&
9efb6d4ed19b 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' &&
9efb6d4ed19b 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 &&
9efb6d4ed19b planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
gga
parents:
diff changeset
12
9efb6d4ed19b 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' &&
9efb6d4ed19b 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' &&
9efb6d4ed19b 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' &&
9efb6d4ed19b 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' &&
9efb6d4ed19b 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' &&
9efb6d4ed19b 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' &&
9efb6d4ed19b 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' &&
9efb6d4ed19b 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' &&
9efb6d4ed19b 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' &&
9efb6d4ed19b planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
gga
parents:
diff changeset
22
9efb6d4ed19b 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'