erkansirin78/postgresdata-101 repository overview

docker run --rm -d \
--name postgresql \
-e POSTGRES_USER=postgres \
-e POSTGRES_PASSWORD=Ankara06 \
-e PGDATA=/var/lib/postgresql/data/pgdata \
-p 5432:5432 \
-v postgresql15_v:/var/lib/postgresql/data \
erkansirin78/postgresdata-101:15

docker exec -it postgresql bash
psql -U postgres
create database adventureworks;

\c adventureworks;
\i /AdventureWorks/install.sql

create database adventureworksdw;
\c adventureworksdw;
\i AdventureWorksDW2012.sql

psql -U postgres -f /lukeb/1_create_database.sql
psql -U postgres -d sql_course -f /lukeb/2_create_tables.sql
psql -U postgres -d sql_course -f /lukeb/3_modify_tables.sql

FROM postgres:15

WORKDIR AdventureWorks

RUN apt update && apt install curl unzip ruby -y

RUN curl -Lo AdventureWorks-oltp-install-script.zip https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks-oltp-install-script.zip

RUN unzip AdventureWorks-oltp-install-script.zip

RUN curl -Lo install.sql https://raw.githubusercontent.com/lorint/AdventureWorks-for-Postgres/master/install.sql

RUN curl -Lo  update_csvs.rb https://raw.githubusercontent.com/lorint/AdventureWorks-for-Postgres/master/update_csvs.rb

RUN ruby update_csvs.rb

RUN curl -Lo AdventureWorksDW2012.sql https://github.com/jonathanDuenas/AdventureWorksDW-PostgreSQL/raw/master/AdventureWorksDW2012.sql

COPY sql_load /lukeb

COPY csv_files.tar.gz /lukeb

RUN cd /lukeb && tar -xzf csv_files.tar.gz