Mercurial > repos > gga > chado_export_export_gbk
annotate prepare_psql.sh @ 21:cfe09b903a3a 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:45:23 +0000 | 
| parents | f591d334d1f8 | 
| children | 
| rev | line source | 
|---|---|
| 
10
 
f591d334d1f8
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 | 
| 
 
f591d334d1f8
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 
gga 
parents:  
diff
changeset
 | 
2 | 
| 
 
f591d334d1f8
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` && | 
| 
 
f591d334d1f8
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 && | 
| 
 
f591d334d1f8
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 
gga 
parents:  
diff
changeset
 | 
5 | 
| 
 
f591d334d1f8
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 && | 
| 
 
f591d334d1f8
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 
gga 
parents:  
diff
changeset
 | 
7 | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
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 && | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
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 && | 
| 
 
f591d334d1f8
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 
gga 
parents:  
diff
changeset
 | 
12 | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
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' && | 
| 
 
f591d334d1f8
planemo upload for repository https://github.com/galaxy-genome-annotation/galaxy-tools/tree/master/tools/chado commit 0b135f1ea2623ea68e41ac88e13d99e6b4ad8bea
 
gga 
parents:  
diff
changeset
 | 
22 | 
| 
 
f591d334d1f8
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' | 
