Web Intelligence Class IT215

Instructor : Eka Rahayu Setyaningsih, S.Kom., M.Kom.

Students : Jeremy Kennedy - 223210693

docker network create --driver=bridge --subnet=172.24.0.0/16 --ip-range=172.24.0.0/16 --gateway=172.24.1.1 docknet

docker run -d --name pgwisql -p 5450:5432 -e POSTGRES_DB=s2 -e POSTGRES_USER=s2usr -e POSTGRES_PASSWORD=s2usr -e PGDATA=/var/lib/postgresql/data -v ${pwd}/docker/postgres:/var/lib/postgresql/data --network docknet --ip 172.24.1.110 postgres:16

docker cp docker/postgres/types.sql pgwisql:/home docker cp docker/postgres/webintelligence.dump pgwisql:/home

docker exec -it pgwisql /bin/bash

psql -h 172.24.1.110 -U s2usr -d s2 -f /home/types.sql pg_restore -h 172.24.1.110 -U s2usr -d s2 /home/webintelligence.dump