docker-compose.yml (Postgres)

web:
  container_name: ubuwebpostgres
  image: fab/ubuntu-postgres
  hostname: web
  ports:
    - "80:80"
    - "8025:8025" # MailHog UI
    - "3306:3306" # To allow connection from the host, e.g.: with Sequel Pro (didn't manage to get it to work.)
    - "5432:5432" # Postgres, in hope of being able to use an OS X client to connect to it once I get it running
  volumes:
    # Mind the order. e.g.: logs before config, so as to catch errors on the host instead of the container.

    # For my own convenience
    - /Users/fabien/LocalDevUbuntuPostgres/tmp-fab:/tmp-fab

    # For supervisor
    - /Users/fabien/LocalDevUbuntuPostgres/logs/supervisor:/var/log/supervisor

    # For Apache2 (includes PHP errors)
    - /Users/fabien/LocalDevUbuntuPostgres/logs/apache2:/var/log/apache2
    - ./config/apache2.conf:/etc/apache2/apache2.conf #TODO: test without it cause there's no such file!
    - /Users/fabien/Dropbox/DEV/Docker/containers/ubuntu/config/sites-available:/etc/apache2/sites-available
    - /Users/fabien/Dropbox/DEV/Docker/containers/ubuntu/config/sites-available:/etc/apache2/sites-enabled
    - /Users/fabien/Dropbox/DEV/vhosts:/var/www/html

    # For Postgres
    #- /Users/fabien/LocalDevUbuntuPostgres/logs/postgresql:/var/log/postgresql
    - /Users/fabien/LocalDevUbuntuPostgres/postgresdata:/var/lib/postgresql/9.6/main # causes Postgres to keep crashing!
    - ./config/pg_hba.conf:/etc/postgresql/9.6/main/pg_hba.conf

    # For MySQL (MariaDB) -- required to migrate data from MySQL to Postgres
    - /Users/fabien/LocalDevUbuntuPostgres/logs/mysql:/var/log/mysql
    - /Users/fabien/LocalDevUbuntuPostgres/mysqldata:/var/lib/mysql


# RUN THIS CONTAINER:
# cd /Users/fabien/Dropbox/DEV/Docker/containers/ubuntu-postgres
# docker-compose up -d
# STOP:
# docker-compose down
# RESTART:
# docker-compose down; docker-compose up -d;
# RESTART AND GET INTO BASH:
# docker-compose down --remove-orphans; docker-compose up -d; docker exec -it ubuwebpostgres /bin/bash