1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62

version: '3.8'

services:
    database-server-mysql:
        image: mysql:8.0.30
        volumes:
            - ./data/database-data-mysql:/var/lib/mysql
            - ./conf/init-scripts/database-mysql:/docker-entrypoint-initdb.d
        restart: always
        environment:
            MYSQL_ROOT_PASSWORD: secret
            MYSQL_DATABASE: dbname
            MYSQL_USER: username
            MYSQL_PASSWORD: secret
        ports:
            - "3306:3306"

    database-gui-mysql:
        image: phpmyadmin/phpmyadmin:5.2.0
        depends_on:
            - database-server-mysql
        restart: always
        environment:
          PMA_HOST: database-server-mysql
          PMA_USER: root
          PMA_PASSWORD: secret
        ports:
          - "8081:80"

    database-server-postgresql:
        image: postgres:15.1
        volumes:
            - ./data/database-data-postgresql:/var/lib/postgresql/data
            - ./conf/init-scripts/database-postgresql:/docker-entrypoint-initdb.d
        restart: always
        environment:
            POSTGRES_DB: dbname
            POSTGRES_USER: username
            POSTGRES_PASSWORD: secret
        ports:
            - "5432:5432"
    
    database-gui-postgresql:
        image: dpage/pgadmin4:6.18
        volumes:
            - ./data/database-gui-data-postgresql:/var/lib/pgadmin
        depends_on:
            - database-server-postgresql
        restart: always
        environment:
          PGADMIN_DEFAULT_EMAIL: dev@aripd.com
          PGADMIN_DEFAULT_PASSWORD: secret
        ports:
            - "5050:80"

    debian:
        image: debian:bookworm
        stdin_open: true # docker run -i
        tty: true        # docker run -t

volumes:
    data:

1

docker compose up -d

1
2
3

apt-get update && apt-get upgrade
apt-get install pgloader sqlite3
pgloader --verbose --no-ssl-cert-verification mysql://username:secret@database-server-mysql:3306/dbname "postgresql://username:secret@database-server-postgresql:5432/dbname"