diff options
| -rwxr-xr-x | automatisation/BDDAuto.sh | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/automatisation/BDDAuto.sh b/automatisation/BDDAuto.sh index 2dcb4f2..87205fa 100755 --- a/automatisation/BDDAuto.sh +++ b/automatisation/BDDAuto.sh @@ -13,9 +13,10 @@ echo atsuser:123456 | chpasswd echo "CREATE USER atsuser WITH PASSWORD '123456'; CREATE DATABASE atsdb; GRANT ALL PRIVILEGES ON DATABASE atsdb to atsuser;" > /tmp/conf +service postgresql start #dernier ajout : Lancement du serveur -su - postgres -c "psql -f /tmp/conf" +su - postgres -c "psql -f /tmp/conf" #creation de l'util atsuser et la bdd atsdb sur le serv psql -pushd /tmp ; su atsuser -c "psql -d atsdb -U atsuser -f /tmp/table.sql" ; popd +pushd /tmp ; su atsuser -c "psql -d atsdb -U atsuser -f /tmp/table.sql" ; popd #mis en place de la table paquet dans la bdd |