Docker db setup

Downloading docker

In order to install docker on windows please download the latest docker toolbox .exe release from the official repo.

Note 1: You need to have Intel VT-x or AMD-V hardware virtualization enabled or the instalation will fail. If this happens, please enable it in your computers's BIOS and retry.

Note 2: If you are running Windows 10 Pro, you can download Docker Desktop which uses native Hyper-V virtualization instead of VirtualBox. In order to be able to run the software in all versions of Windows 10 we chose to use the toolbox version. Choose whichever version you prefer at your own risk.

Installing Docker

1. Run the installer using the full instalation configuration and remember to tick the option to install VirtualBox.
2. Run the Docker Quickstart Terminal shortcut and wait for the setup to finish.

Setting up the database

1. Open the Docker Quickstart Terminal or whichever shell you prefer (admin access may be needed)
2. Navigate to the /II_project/db directory
3. Run: docker-compose up -d
4. After the containers are created you can check on them using: docker ps

You can now access the PgAdmin webpage by going to your prefered browser and entering the following adress:

<YOUR-DOCKER-MACHINE-IP>:5050

Where your <YOUR-DOCKER-MACHINE-IP> is usually by default 192.168.99.100 if not, you can check it by running docker-machine ip on the shell. If you are using Docker Desktop this IP should instead be the localhost but I have not tested it.

If you wish to setup the database server automatically run:

docker exec -it pgadmin_container python3 /pgadmin4/setup.py --load-servers /cfg/servers.json --user [email protected]

To delete all containers and data run:

docker-compose down --volumes

Default Credentials

pgadmin

User: [email protected]

Password: admin

---

database

User: ii

Password: iisuckz