Changes between Version 12 and Version 13 of SystemAdministration/Hosts/clarinvm.ics.muni.cz

Timestamp:

09/17/15 08:13:40 (9 years ago)

Author:

Willem Elbers

Comment:

--

SystemAdministration/Hosts/clarinvm.ics.muni.cz

@@ -73 +73 @@
 
 {{{
-sudo docker create --name pg_compreg_data -v /var/lib/postgresql/9.3/main/ tianon/true
-sudo docker run -d --name pg_compreg -v /home/wilelb/compreg/:/data/ -p 172.17.42.1:5432:5432 --volumes-from pg_compreg_data docker.clarin.eu/pg-compreg:1.0.0
+#Create postgres container with data volume container
+sudo docker create --name postgres_data -v /var/lib/postgresql/9.3/main/ docker.clarin.eu/pg-compreg:1.0.0
+sudo docker run -d --name postgres --restart=always -v /home/wilelb/compreg/:/data/ -p 172.17.42.1:5432:5432 --volumes-from postgres_data docker.clarin.eu/pg-compreg:1.0.0
+
+#Create database and import backup
+sudo docker exec -ti postgres createuser -P compreg
+sudo docker exec -ti postgres createdb -O compreg compreg
+sudo docker exec -ti postgres psql -f /data/compreg.20150917.sql -h localhost -U compreg -W compreg
 }}}