set -euxo pipefail

DIR=${0%/*}

source "${DIR}/_prerequisites.ubuntu.sh"

source "${DIR}/_zfs.file.sh"

sudo docker run \

--name dblab_pg_initdb \

--label dblab_sync \

--env PGDATA=/var/lib/postgresql/pgdata \

--env POSTGRES_HOST_AUTH_METHOD=trust \

--volume /var/lib/dblab/data:/var/lib/postgresql/pgdata \

--detach \

postgres:12-alpine

while true; do

sudo docker exec -it dblab_pg_initdb psql -U postgres -c 'select' && break

sleep 1

sudo docker exec -it dblab_pg_initdb psql -U postgres -c 'create database test'

sudo docker exec -it dblab_pg_initdb pgbench -U postgres -i -s 10 test

sudo docker stop dblab_pg_initdb

sudo docker rm dblab_pg_initdb

set -euxo pipefail

ZFS_FILE="$(pwd)/zfs_file"

sudo docker rm -f dblab_pg_initdb || true

sudo zpool destroy test_pool || true

sudo umount /var/lib/dblab/data || true

sudo rm -f "${ZFS_FILE}"

set -euxo pipefail

curl --version || sudo apt-get update && sudo apt-get install -y \

apt-transport-https \

ca-certificates \

curl \

gnupg-agent \

software-properties-common

curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -

sudo add-apt-repository \

"deb [arch=amd64] https://download.docker.com/linux/ubuntu \

docker --version || sudo apt-get update && sudo apt-get install -y \

docker-ce \

docker-ce-cli \

containerd.io \

zfsutils-linux

set -euxo pipefail

ZFS_FILE="$(pwd)/zfs_file"

truncate --size 1GB "${ZFS_FILE}"

sudo zpool create -f \

-O compression=on \

-O atime=off \

-O recordsize=8k \

-O logbias=throughput \

-m /var/lib/dblab/data \

test_pool \

"${ZFS_FILE}"

zfs list